It is not the same. MS Access uses ethe Jet database engine. But, really, it's all quite simple (at least, in my experience, but I'm not trying to bridge a Zope instance under Linux to a Windows box's ODBC source). You want to create a system database connection to the Access database. This will provide the ODBC data source on the Windows box that Zope can talk to. Try looking at Start | Settings | Control Panel | Administrative Tools | Data Sources (ODBC). You'll instruct the OS to use the particular Access files, and to give it a global name of your choosing, which you'll use when you set up the Zope connector. There might be things you have to do on the Linux end to make the actual connection to the Windows machine, but doing the above will expose the Access database as an ODBC data source. Alternatively, if you have an MS Office 2k cd, hunt around for MSDE -- this is a freely redistributable drop-in module that looks and acts just like SQL Server, with some limitations. Access can export its database to the MSDE db, and then you'll have a version you can treat as SQL Server, with the performance benefits thereto. -----Original Message----- From: Mark Gibson [mailto:mark@dimensional.com] Sent: October 29, 2002 10:57 This talks about connect to a WinNt-MSSQLServer from linux. Is this the same thing as the MS Access DB? I'm quite unfamiliar with MS products, so any help is appreciated.
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 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
Hi all, I have done an other recherche for solving a connection from Linux Zope to MS Access DB: You need: http://www.zope.org/Members/haqa/ZDataQueryKit (ODBC Client) http://odbcsock.sourceforge.net/ (ODBCSocketServer) Dieter Maurer pointed to ODBCSocketServer, but the Python method I found there didn't worked for me. But ODBCSocketServer pointed me the XMLKit and from there I went to ZDataQueryKit. Zope - everything goes ... Regards, Dirk
participants (2)
-
Dirk Datzert -
Keith J. Farmer