It works fine with a system DSN,

But when a user renames the database, you have to recreate a DSN each time.

Is there any way to create a DNS without the database name/path and then
specify it from the perl script in the connect string ?

Etienne

Bart Lateur wrote:

> On Tue, 23 Oct 2001 10:55:57 -0400, Etienne Marcotte wrote:
>
> >I made an access DB, created an ODBC DNS with windows 2000 utility
> >(altough I'm not sure I did everything correctly)
> >
> >When I try the connect string:
> >
> >dbi:ODBC:driver=Microsoft Access Driver (*.mdb);dbq=c:\\clients.mdb
>
> Just a thought: why aren't you simply creating a (system) DSN with the
> ODBC Contol Panel, and simply reference that by name? The connect string
> then can simply be
>
>         DBI:ODBC:yourDSN
>
> --
>         Bart.

S/MIME Cryptographic Signature

Reply via email to