-----Original Message----- From: Andy Gates <Andy.Gates@bristol.ac.uk> To: zope@zope.org <zope@zope.org> Date: donderdag 18 mei 2000 11:24 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!
Hm, a few possibilities I haven't seen yet: - You don't happen to have spaces in the Access file name? This may upset one object or another. - There isn't an Access workgroup type of authentication going on (just checking) Rik