Then use a dsnless connection. Look at perldoc DBD::ODBC for the examples
(connecting to Access) that are already listed.
--Neil
>-----Original Message-----
>From: Michael Blackmore [mailto:[EMAIL PROTECTED]]
>Sent: Monday, July 30, 2001 10:51 AM
>To: [EMAIL PROTECTED]
>Subject: DBI::ODBC configuration of DSN within program.
>
>
>Dear Dbi-Users,
>
>I have a number of MS Access databases (30+) that all have the same
>structure. I would like to configure my DSN so that it points
>to each of
>these databases in turn, I can then extract the information I want.
>Does anyone know if this is possible? I don't really want to
>configure the
>DSN for each database manually.
>
>Cheers,
>
>Michael
>
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail. If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately. The contents
of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.