This is what I am doing to connect toa database :
#Windows-based Perl/DBI/MS Access access
use DBI;
#open connection to Access database
$dbh = DBI->connect('dbi:ODBC:MSMuseum');
#prepare and execute SQL statement
$sqlstatement="SELECT * FROM Product";
$sth = $dbh->prepare($sqlstatement);
$sth->execute ||
die "Could not execute SQL statement ... maybe invalid?";
#output database results
while (@row=$sth->fetchrow_array)
{ print "@row\n" }
I am using a DSN for my database. One of the websites I visited said that you can
connect to the database without a DSN. How is that done ?
Kamali
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]