Have you defined myDB in windows ODBC? It is under settings/control
panel/administrative tools/data sources ODBC.
At 02:40 PM 1/6/2006, Hsu, David wrote:
Hi all,
Has anyone else run into this problem and have found a solution?
I am making an ODBC connection to a remote MS Access DB from my
web server. When my Perl script runs, it cannot open the data source.
I tested the connection using MS Query, and it is fine. Why can't Perl
access the DB?
Here is how I'm connecting to the DB.
Thanks,
David
...
my $DSN = 'myDB';
my $db=new Win32::ODBC($DSN); #create new instance
if (! $db){
perror("Error opening data source $DSN");
exit(0);
}
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs