RE: ODBC connects, but queries fail.

[Sterin, Ilya]

$driver = "driver={Microsoft Access Driver
(*.mdb)};DBQ=C:/databases/products.mdb";
$dbh = DBI->connect("dbi:ODBC:$driver");

Ilya Sterin


-----Original Message-----
From: Jack McKinney
To: [EMAIL PROTECTED]
Sent: 05/10/2001 7:04 AM
Subject: Re: ODBC connects, but queries fail.

Big Brother tells me that Neil Lunn wrote:
> Jack,
> 
> Just as an extra check. What do you get if you fully qualify the DSN
in the
> dbi connect string?
> (that is, a DSN'less connection) ie "dbi:ODBC:driver= 'etc'"

    I am not familiar with this syntax.  I have used MySQL with DBI
before,
but no other driver.  This is my first attempt at ODBC from perl.

--
"No eels were harmed in the        Jack McKinney
 filming of this show"             [EMAIL PROTECTED]
  -caption from Frasier            http://www.lorentz.com
1024D/D68F2C07 4096g/38AEF076