[Zope] MS Access odbc connection string problem

Kelley, Sean SKelley@ci.santa-rosa.ca.us
Mon, 16 Jun 2003 11:47:50 -0700

I am trying to setup an ODBC connection to an MS Access database which is
located on another network server (windows network).  I have been successful
connecting to MS SQL but I cannot get me Access connection to work.

When setting up the ODBC connection in windows control panel on the zope
server I use the unc path \\\server\folders\mydb.mdb to get to the Access
file and create a system DSN.  When I try to create the connection object in
zope and connect to this database I get an error Invalid connection string:
when using the dsnname username password format
Is there a problem creating or using a system DSN with the ZODBC connector
when the location of the database file is on another server other than the
zope server?
With SQL I use the sql user to authenticate in the connection string.  With
Access does one use the windows user with rights to the file or the user
created in the Access file itself to connect?  I have tried both so far.

Any help would be appreciated.