[Zope] MS Access Db

Keith J. Farmer kfarmer@thuban.org
Tue, 29 Oct 2002 11:38:13 -0800


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]=20
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.