[Zope] Newbie: MS Access ODBC connection strings

michael angelo ruberto michaelangelo@intelligenesis.net
Thu, 18 May 2000 13:25:46 -0400


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 )