[Zope-DB] Z ODBC and Access problem

[Chris Gray]

On Tue, 6 May 2003, 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

I tracked down the problem, and thought what I discovered would be of
interest.

It seems I only get the "Invalid connect string" message when the database
is on a mapped network drive.  If the file is on the machine that is
running Zope, there's no problem.

Chris