Turn on tracing in the driver manager in odbcinst.ini [ODBC] Trace=Yes TraceFile=/tmp/sql.log
Have a look to see whats being passed to SQLDriverConnect and SQLConnect, you may need a DSN= in front of the connect string. Tim Harsch wrote: > Hi all, > I was upgrading my DBD::ODBC from 0.28 to 0.38. The > tests seemed fine. But after make install none of my > scripts can connect anymore. I get this error: > > [root@perseus installs]# testODBC.pl > DBI->connect(HOMER;DBN=devel) failed: > [unixODBC][Driver Manager]Data source name not found, > and no default driver specified (SQL-IM002) > [unixODBC][Driver Manager]Data source name not found, > and no default driver specified (SQL-IM002)(DBD: > db_login/SQLConnect err=-1) at ./testODBC.pl line 8 > > My setup: > Redhat Linux 7.0 > DBI 1.21 > DBD::ODBC 0.38 > EasySoft ODBC::ODBC bridge software > perl 5.6 > SQL Server 2000 > > Please help! > > __________________________________________________ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com