Hi Javier, > I am trying to access an MS Access database via perl DBI and I am unable to. > I checked the security and there is only one 'Admin' user with no password > and I use that in my connection string. However, I cannot connect. Please > help. >
1. Create an ODBC connection via %SystemRoot%\system32\odbcad32.exe Call the database connect name "ODBCName" 2. In your Perl code add: [---] use DBI; [---] $dbh = DBI->connect("dbi:ODBC:ODBCName",'',''); [---] $sth = $dbh->prepare("select * from some_tablename"); $sth->execute || die("Could not execute SQL statement ... maybe invalid?"); while (@row_data = $sth->fetchrow_array()) { print $row_data[0]; ### print first column of table 'some_tablename' } ...That's really about it... everything else is on an as-needed basis. If the database is on a network drive, maybe there is some sort of permissions issue going on. Post some code. kevindot