Where did you find those docs? They need to be corrected.
All the examples that appear in the fine manual (perldoc DBD::ODBC) show it
in uppercase and the DBI manual states that the case of the driver name does
matter. The 'dbi' in the DSN is supposed to be lowercase, but uppercase has
been allowed for some time. If you can use lower case for ODBC in your
platform, don't count on
being able to do it in the future.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
----- Original Message -----
From: "Jack McKinney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 8:41 AM
Subject: Re: DBD::ODBC doesn't work!!!
Big Brother tells me that Bodo Eing wrote:
> Jack,
>
> > Help! I cannot get DBD::ODBC to work. I am connecting to the
> > MSSQL 2000 database with:
> >
> > $db = DBI->connect("dbi:odbc:MSSQLTEST");
> >
>
> In the first place, try connecting with the correct capitalization of
> the driver and add error checking:
>
> $db = DBI->connect("DBI:ODBC:MSSQLTEST") or die DBI::errstr();
Hmmm... the examples in the docs all had lower case. I would think that
the output I am getting (see previous email for errors messages and a copy
of the script) would not mention unixODBC if the lower case dbi and odbc
did not work, since it wouldn't look for an ODBC manager...
My code (see previous email) does error check here, and the code does
not complain.
