[Zope] Newbie: MS Access ODBC connection strings

[Rik Hoekstra]

-----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