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

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!

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

Replies are listed 'Best First'.
Re: Re: Re: WIN32:ODBC Perl Connection to Micros~1 Access Database by mr_dont (Beadle) on Jan 05, 2002 at 06:49 UTC
Oops, I didn't log in... that was me, Mr. Don't!	[reply]
Re: Re: Re: WIN32:ODBC Perl Connection to Micros~1 Access Database by cheshirecat (Sexton) on Jan 06, 2002 at 01:06 UTC
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]