[Zope] MS Access Db

[Dirk Datzert]

Dies ist eine mehrteilige Nachricht im MIME-Format.
--------------C66BA7572A1F3F409EE97DEC
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

I did some research on the Internet. I have still the same problem.

I've downloaded the ZODBCDA product from zope.org . I read that this
comes for Windows __only__, but someone has compiled it on UNIX
system for use with SOLID..., don't know what he meant, but thought
that the same source should run with little modification on linux.

Searching for a ODBC driver/includes on linux I came to unixODBC.org .
I've downloaded the sources and installed it like the INSTALL 
instructions told me.

For MS Access Db you will need EasySoft ODBC-ODBC Brige from 
www.easysoft.com . This is not OpenSource, but for testing you get a
30-trial license.

I attached a patch for ZODBCDA to use unixODBC .

Maybe someone can tell me how I can connect from Zope to 
EasySoft ODBC-ODBC bridge 

Regards,
Dirk
--------------C66BA7572A1F3F409EE97DEC
Content-Type: text/plain; charset=us-ascii;
 name="ZODBCDA-unixODBC.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="ZODBCDA-unixODBC.patch"

diff -uNr ZODBCDA/src/Setup /tmp/lib/python/Products/ZODBCDA/src/Setup
--- ZODBCDA/src/Setup	Tue Oct 29 22:45:32 2002
+++ /tmp/lib/python/Products/ZODBCDA/src/Setup	Wed Jan  6 20:20:06 1999
@@ -1,10 +1,7 @@
 *shared*
 
-# Use this for Linux unixODBC
-sql sql.c -DOS_LINUX -L/usr/local/lib -lodbc -I/usr/local/include
-
 # Use this for Solid
-#sql sql.c -DSOLIDSQLAPI -I/usr/local/solid/include /usr/local/solid/lib/scllux22.a
+sql sql.c -DSOLIDSQLAPI -I/usr/local/solid/include /usr/local/solid/lib/scllux22.a
 
 # Or maybe this for Solid 2.3, based ob feedback from Andrew Kuchling:
 #sql sql.c -DSOLIDSQLAPI -I/usr/local/solid/include -L/usr/local/solid/lib -lsolcli
diff -uNr ZODBCDA/src/sql.c /tmp/lib/python/Products/ZODBCDA/src/sql.c
--- ZODBCDA/src/sql.c	Tue Oct 29 20:22:39 2002
+++ /tmp/lib/python/Products/ZODBCDA/src/sql.c	Fri Jan  8 16:30:25 1999
@@ -585,11 +585,7 @@
 }
 
 #else
-
-#if ! defined OS_LINUX
 #include <windows.h>
-#endif /* ! defined OS_LINUX  */
-
 #include "sql.h"
 #include "sqlext.h"
 #endif

--------------C66BA7572A1F3F409EE97DEC--