> my $dbh = DBI -> connect ('dbi:msaccess:perl ;Machinename' ,'username','
> password')

my $dbh = DBI->connect ("dbi:ODBC:$dsn", 'username', 'passwd');

If you don't want to define a DSN then try something like:

my $dbq = 'C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb';
my $driver = 'Microsoft Access Driver (*.mdb)';
my $dsn = "DRIVER=$driver;DBQ=$dbq";

my $dbh = DBI->connect ("dbi:ODBC:$dsn", 'username', 'passwd');

--
  Simon Oliver

Reply via email to