This is what I am doing to connect toa database :

[Kamali Muthukrishnan]

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]