There is also the unixODBC project, which has vowed to bring ODBC freely to Unix and in particular Linux. MySQL and PostgreSQL drivers are available. "The unixODBC Project goals are to develop and promote unixODBC to be the definitive standard for ODBC on the Linux platform. This is to include GUI support for KDE." http://www.unixodbc.org/ -- Alexander Staubo http://www.mop.no/~alex/ "Reality is that which, when you stop believing in it, doesn't go away." --Philip K. Dick

-----Original Message----- From: hannu@kodu.home.ee [mailto:hannu@kodu.home.ee]On Behalf Of Hannu Krosing Sent: 20. juli 1999 11:19 To: Christopher Petrilli Cc: Roman Milner; zope@zope.org Subject: Re: [Zope] ODBC DA for unix coming?

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

_______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope

(For developer-specific issues, use the companion list, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )