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

Reply via email to