Connecting to an Access database
Hi there, I am trying to connect to an MSAccess database. I have downloaded and installed the zodbca database adaptor, and I am able to select "ZODBC databse connection" from the ADD list. I have created an Access database in zope_home/Access_dbs called "test.mdb" However I do not know what to put for a connection string... What should the "data source name" be? I tried using the pathname to the databse, ie "C:\Program Files\WendyZopePlay\Access_dbs\test.mdb" - however this generates an "Invalid connection String" Error. I do not think that the database needs a password, or at least I wasn't asked about one when I created it, so would I just leave "username" and "password" blank? zope seems to just "know" where the gadfly databases are kept, ie in /var/gadfly, but how would I tell it where other databases are? Could anyone let me know or direct me to some documentation? Thank you :) _________________________________________ Wendy Langer ICQ#: 71726799 More ways to contact me: http://wwp.icq.com/71726799 See more about me: http://web.icq.com/whitepages/about_me?Uin=71726799 _________________________________________
From: "Wendy Langer" <wlanger@bigpond.net.au>
However I do not know what to put for a connection string...
The name of the ODBC Data source. In fact, you don't have to enter a connection string, the ODBC data source shows up in the list of data sources. You can just select it there. So what you have to do is to create an ODBC Datasource for your Access databse. This is done in the Windows control panel.
participants (2)
-
Lennart Regebro -
Wendy Langer