Re: [Zope] ODBC DA for unix coming?
Well, I know that mxODBC (http://starship.python.net/crew/lemburg/mxODBC.html) is a python DB API 2.0 interface that works on top of the free IODBC (http://www.iodbc.org).
I don't really know what I'm talking about - but it would be really nice to have an ODBC interface. The Cold Fusion guys at work seem to be able to get Cold Fusion to work with any DB ("OH, we'll just use the ODBC driver.") Some day, I hope to sell them Zope.
There are three levels really to ODBC: 1. The "ODBC adapter" (such as mxODBC, etc) 2. The manager (such as iODBC) 3. The database driver (such as Oracle, etc.) At least this has been my understanding I've been operating under. I just looked at iODBC, and I don't see anything in it to let it talk to say, Microsoft SQL Server (an ODBC only database, unless you know that it's really only Sybase underneath :-). How would I do this? Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
Christopher Petrilli wrote:
There are three levels really to ODBC:
1. The "ODBC adapter" (such as mxODBC, etc) 2. The manager (such as iODBC) 3. The database driver (such as Oracle, etc.)
At least this has been my understanding I've been operating under. I just looked at iODBC, and I don't see anything in it to let it talk to say, Microsoft SQL Server (an ODBC only database, unless you know that it's really only Sybase underneath :-).
Your current solution would probably be to go to http://www.openlink.co.uk and get their multi-tier odbc drivers with db-independent communication layer and use that for connecting to most known databases. The GPL-ed iODBC is just a driver manager.
How would I do this?
The freeTDS is planning to implement a free ODBC driver for MSSQL, currently they have just the lower protocol levels. See http://metalab.unc.edu/freetds/ . There also seem to exist ODBC drivers for MySQL and ADABAS (according to http://www.applix.com/appware/linux/index.htm). -------------- Hannu
Hannu Krosing wrote:
Your current solution would probably be to go to http://www.openlink.co.uk and get their multi-tier odbc drivers with db-independent communication layer and use that for connecting to most known databases.
And they even have a nice pilot program : You can download a free non expiring license for: 2 Concurrent Client Machines and 10 Concurrent Database Sessions I'm not sure about the exact license terms, but it's very likely that you can at least test your adapters ;) --------- Hannu
participants (2)
-
Christopher Petrilli -
Hannu Krosing