-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Christopher Petrilli Sent: 20. juli 1999 11:19 To: Roman Milner Cc: zope@zope.org Subject: 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.
Don't confuse this will conformance levels, though, which is the meaning most common used for word "level" in respect to ODBC. ODBC defines three levels of API conformance (different features supported): Core, Level 1 and Level 2. Transaction support and asynchronous execution of functions, for example, are required of a level 1-conformant driver.
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?
You would use a driver that supports the TDS protocol (which what the FreeTDS project tries to emulate) used by Sybase and Microsoft. Since MS 6.5 and Sybase was essentially the same product until version 4.2, they share much of the same innards, and you should be able to use a Sybase ODBC driver with MS, and vice versa. It may be the only known case of cross-platform product interopability in Microsoft's history. ;-) SQL Server is not an ODBC-only database. Its native API used to be the DB-Library. This API has been partly deprecated by MSSQL 7.0 -- if you want any of the new features of 7.0, you're forced to use any of the newer APIs such as ODBC, OLE DB, ADO (ActiveX Database Objects), or RDO (Remote Data Objects; a VB thing).
Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
-- Alexander Staubo http://www.mop.no/~alex/ "Reality is that which, when you stop believing in it, doesn't go away." --Philip K. Dick