Re: ODBC connects, but queries fail.

[Jack McKinney]

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;ConnectTimeout=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.

PGP signature