[Zope-DB] Z ODBC and Access problem

M.-A. Lemburg mal@lemburg.com
Tue, 06 May 2003 22:08:43 +0200

Chris Gray wrote:
> I've just moved an instance of Zope from Windows 98 to Windows XP, but I
> can't get odbc connections to an Access database to work; all I get is an
> "Invalid connection string" error message.
> I can set up a DSN for a remote PostgreSQL database and it works fine in a
> Z ODBC connection.  I can get the DSN for the Access database to work with
> other applications, but I can't get Zope to play nice with the Access DSN.
> Any ideas?
> Zope 2.6.1 (binary release, python 2.1, win32-x86), python 2.1.3, win32)
> ZODBCDA 3.1.0b2, win32, python 2.1

You may want to try the mxODBC Zope DA. We haven't had any problems
connecting to Access or MS SQL Server.

Marc-Andre Lemburg

Professional Python Software directly from the Source  (#1, May 06 2003)
 >>> Python/Zope Products & Consulting ...         http://www.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
EuroPython 2003, Charleroi, Belgium:                        49 days left