Database connectivity

[Robert Brewer]

Others have made good points and pointers. Just wanted to make sure you
knew that you should be able to use ADO for MSSQL connections, as well.
The only serious change to your code will be using "NText" instead of
"Memo" types. Subclass your existing connectors and off you go, probably
within a day's coding or less. Then you can hunker down and consider the
cross-platform stuff.


Robert Brewer
MIS
Amor Ministries

> -----Original Message-----
> From: SectorUnknown [mailto:secun at yahoo.com] 
> Sent: Monday, November 24, 2003 9:16 AM
> To: python-list at python.org
> Subject: Database connectivity
> 
> 
> I've written a database (Access mdb) front-end using 
> Python/wxpython/and 
> ADO. However, the scope of the project has changed and I need 
> to access 
> the same data on an MSSQL server. Also, the front-end needs 
> to be cross-
> platform (Windows and Linux). 
> 
> Does anyone have any suggestions on what database 
> connectivity I should 
> use? I've looked at mxODBC and wxODBC briefly, but am not 
> sure what is 
> the best way to go.
> 
> BTW, although I would love to move away from the MSSQL server, that's 
> not going to change.
> -- 
> http://mail.python.org/mailman/listinfo/python-list
>