-----Original Message-----
From: Andy Gates <[EMAIL PROTECTED]>
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
>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


Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to