in reply to Trouble with accessing MS Access database via Perl on web host........
Update: The "Open" string above is using the Access 2000 driver installed with ADO 2.5, you can substitute that line for :use strict; use OLE; my $dbh; $dbh = CreateObject OLE "ADODB.Connection" or die "Can't create connec +tion to DataBase: $!" unless $dbh; $dbh->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\_private\\ +db1.mdb"); my $sql = "SELECT email, password FROM surya"; my $rs = $dbh->Execute($sql); while (!$rs->EOF()) { print $rs->Fields('email')->Value . " " . $rs->Fields('password')- +>Value . "\n"; $rs->MoveNext; } $dbh->Close();
$dbh->Open("Driver={Microsoft Access Driver (*.mdb)};DBQ=\\_private\\d +b1.mdb");
|
|---|