DBI->connect(Driver=/usr/local/lib/odbc-i02.so;Se....... ????????
You still must use DBI->connect("dbi:ODBC:dsn_string_here")
Ilya Sterin
-----Original Message-----
From: Jack McKinney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 10:53 PM
To: '[EMAIL PROTECTED] '
Subject: Re: ODBC connects, but queries fail.
Big Brother tells me that Neil Lunn wrote:
>
> Nonetheless the concept it the same, and is part of the ODBC
specification.
> Look at all the entries in your DSN TEST ie hostname=myhost or
whatever. You
> supply these as the DSN string in your connect statement.
OK. I see. Here is what I got:
DBI->connect(Driver=/usr/local/lib/odbc-i02.so;Server=mssql.mydomain.com
;User=myuser;Pass=mypass;Database=testdb;Majorver=4;Minorver=2;ConnectTi
meout=30;Trace=Yes;TraceFile=/tmp/odbc-mssql;) failed: [unixODBC][Driver
Manager]Data source name not found, and no default driver specified
(SQL-IM002)
[unixODBC][Driver Manager]Invalid string or buffer length
(SQL-S1090)(DBD: db_login/SQLConnect err=-1) at ./test4.pl line 11
[unixODBC][Driver Manager]Data source name not found, and no default
driver specified (SQL-IM002)
[unixODBC][Driver Manager]Invalid string or buffer length
(SQL-S1090)(DBD: db_login/SQLConnect err=-1) at ./test4.pl line 11.
