perl as win32 and DSNless con to mdb?

[rob merritt]

Hi here is wat I am trying:

use Win32::ODBC;


#my $dsn = "Provider=Microsoft.Jet.OLEDB.4.0;
dbq=h:/logs/mail/report/addressTrack.mdb";

my $dsn = 'driver=Microsoft Access
Driver(*.mdb);dbq=h:/logs/mail/report/addressTrack.mdb';


my $myDb = new Win32::ODBC($dsn);
#
if (!$myDb)
{
print "failed to conect to $DSN\n";
Win32::ODBC:umpError();
die;
}



what I get is:

H:\logs\mail\report>perl addresstrack.pl
failed to conect to

---------- Error Report: ----------
Errors for the package:
Connection Number:
Error number: 911
Error message: "[Microsoft][ODBC Driver Manager] Data source name not
found and
no default driver specified"

 

[mgarrish]

Hi here is wat I am trying:

use Win32::ODBC;


#my $dsn = "Provider=Microsoft.Jet.OLEDB.4.0;
dbq=h:/logs/mail/report/addressTrack.mdb";

my $dsn = 'driver=Microsoft Access
Driver(*.mdb);dbq=h:/logs/mail/report/addressTrack.mdb';

^^

Spaces are important! Change $dsn to:

my $dsn = 'driver=Microsoft Access Driver
(*.mdb);dbq=h:/logs/mail/report/addressTrack.mdb';

and it should connect.

Matt