in reply to WIN32:ODBC Perl Connection to Micros~1 Access Database

Try changing DNS=$database_path to
DSN=$database_path

DSN stands for Data Source Name and NOT Domain Name Service

You could also look at roth.net as Dave Roth was responsible for this module.

Cheers
CheshireCat :)

  • Comment on Re: WIN32:ODBC Perl Connection to Micros~1 Access Database

Replies are listed 'Best First'.
Re: Re: WIN32:ODBC Perl Connection to Micros~1 Access Database
by Anonymous Monk on Jan 05, 2002 at 06:47 UTC

    Good eye Cheshire, but that actually was my own typo, it doesn't work even with "DSN". Actually, this is strange, I can put anything there and it still doesn't crash! I would expect the constructor to throw an exception if it gets messed up connection data... I used "SuperTRONICON2001" as my user name (that's not really my user name) and it still didn't give me any errors until I started using other object methods!

[reply]

      Oops, I didn't log in... that was me, Mr. Don't!

[reply]
      The way I do this is to create a DSN using the ODBC Control panel in Windows. I usually create a system DSN, then I use the name I give it as my name in the connection string.

      This way the dsn can point at any database I want (including excel or access or MS SQL)

      Cheers

      Cheshire Cat

[reply]

In Section Seekers of Perl Wisdom