[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
eGenix.com
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