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