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


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
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 )

Reply via email to