Yes. It's no problem if the Access DB is on the server itself and I create an ODBC connection to it.
David -----Original Message----- From: Ken Barker [mailto:[EMAIL PROTECTED] Sent: Friday, January 06, 2006 6:06 PM To: Hsu, David; perl-win32-users@listserv.ActiveState.com Subject: Re: remote ODBC problem 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