On Apr 11, 2005 12:35 PM, Moreno, Javier <[EMAIL PROTECTED]> wrote: > Ok. I have tried ADO as well with no luck. Please help! > > <snip> > > # Include CPAN modules for DB communication > use DBI; > #use DBD::ODBC; > use DBD::ADO; > #use Win32::OLE; > > # Use these pragmas to code correctly > use strict; > > # Include custom functions > require "Functions.pl"; > > # Debug > $::DEBUG=1; > > # Connect to the database, return error message if something went wrong > my ($path_to_mdb_file) = '\\slpmxwtstandclu\testdata$\Data_2.mdb';
Aha! You are attempting to connect to a database on what looks like a network share. My guess is this is probably not a Perl issue, but rather a network authentication issue- Try to create an empty text file on "'\\slpmxwtstandclu" from the same account you're running your script from... If you can, then my guess is there's something funny going on in the Access DB. But if you can't, then make sure the network account from which you physically run the perl script has read/write permissions for the network resource you are using.... and if you schedule this perl script to run at a specific time, you have to make sure the definition of the scheduled task ALSO has the network authentication parameters (user name / passwd) correct. HTH- kc
