Tried both of these, share has same security as user that starts Zope service. hmmm... -----Original Message----- From: Meilicke, Scott [mailto:scott.meilicke@intp.com] Sent: Monday, June 16, 2003 11:54 AM To: Kelley, Sean; 'zope@zope.org' Subject: RE: [Zope] MS Access odbc connection string problem I am just using the dsnname, no username or password. I also don't have a username/password within the database itself. Ensure the user that is running the zope service has access to the share where the database lives. Scott -----Original Message----- From: Kelley, Sean [ mailto:SKelley@ci.santa-rosa.ca.us <mailto:SKelley@ci.santa-rosa.ca.us> ] Sent: Monday, June 16, 2003 11:48 AM To: 'zope@zope.org' Subject: [Zope] MS Access odbc connection string problem 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. Sean _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope <http://mail.zope.org/mailman/listinfo/zope> ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce <http://mail.zope.org/mailman/listinfo/zope-announce> http://mail.zope.org/mailman/listinfo/zope-dev <http://mail.zope.org/mailman/listinfo/zope-dev> ) The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.