i had a similar problem recently. my access DB was not showing up in the data sources list until i deleted the ODBC connection from windows control panel and recreated it - i guess i messed up the first time. make sure your DB shows up in the "User Data Sources" list in the ODBC Data Source Administrator in Windows and in the ODBC Data Source list in the "Add Z ODBC Database Connection" screen in ZOpe. my connection string is simply the database name. now that i have a working connection all of my tests fail. does anyone know why? -<mike>- -----Original Message----- From: Andy.Gates@bristol.ac.uk [mailto:Andy.Gates@bristol.ac.uk] Sent: Thursday, May 18, 2000 5:19 AM To: zope@zope.org Subject: [Zope] Newbie: MS Access ODBC connection strings Before you all start, I know, MS Access is pants and I should be using a "real" database. And I shall, once the "proof of concept" stage is passed and I can migrate the existing data over to one. But for now I'm stuck with it. Right, that over, here's my plea: I'm trying to create a connection object to a MS Access 97 database. I've installed the ODBC DA product but I cannot get my connection to actually connect. The error I get is, "invalid connection string: project," (project is the DSN name). According to the docs that come with the ODBC-DA, there's usually no need for a connection string and accordingly I have left it blank; I presume that the DA is defaulting to connecting using the DSN name as its string. The database has no security settings that might limit access. What's going wrong? Help! ---------------------- Andy Gates, Learning and Research Technology Andy.Gates@bristol.ac.uk - ICQ#74362415 _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )