Hi all,
Here's more info on the ODBC not connecting problem.
It doesn't seem to provide much insight, maybe you'll
have better luck though ...
-----
Here's a DBI trace of a simple connect attempt:
DBI 1.21-nothread dispatch trace level set to 2
Note: perl is running without the recommended perl
-w option
-> DBI->connect(DBI:ODBC:HOMER, omodify, ****, )
-> DBI->install_driver(ODBC) for linux perl=5.006
pid=23194 ruid=0 euid=0
install_driver: DBD::ODBC version 0.38 loaded
from
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/ODBC.pm
<- install_driver= DBI::dr=HASH(0x8182b78)
-> connect for DBD::ODBC::dr
(DBI::dr=HASH(0x8182b78)~0x8158388 'HOMER' 'omodify'
**** HASH(0x815ec18))
Driver connect 'HOMER', 'omodify', 'xxxx'
SQLConnect 'HOMER', 'omodify', 'xxxx'
dbd_error: SQLError returned -2 unexpectedly.
dbd_error: SQLError returned -2 unexpectedly.
dbd_db_login/SQLSetConnectOption error -2 recorded:
(Unable to fetch information about the error)(DBD:
dbd_db_login/SQLSetConnectOption err=-2)
!! ERROR: -2 '(Unable to fetch information about
the error)(DBD: dbd_db_login/SQLSetConnectOption
err=-2)'
<- connect= undef at DBI.pm line 471
-> errstr in DBD::_::common for DBD::ODBC::dr
(DBI::dr=HASH(0x8182b78)~0x8158388)
<- errstr= '(Unable to fetch information about the
error)(DBD: dbd_db_login/SQLSetConnectOption err=-2)'
at DBI.pm line 472
DBI->connect(HOMER) failed: (Unable to fetch
information about the error)(DBD:
dbd_db_login/SQLSetConnectOption err=-2) at
../testODBC.pl line 11
DBI->connect(HOMER) failed: (Unable to fetch
information about the error)(DBD:
dbd_db_login/SQLSetConnectOption err=-2)
-> $DBI::errstr (&) FETCH from
lasth=DBI::dr=HASH(0x8158388)
>> DBD::ODBC::dr::errstr
-> $DBI::errstr (&) FETCH from
lasth=DBI::dr=HASH(0x8158388)
>> DBD::ODBC::dr::errstr
(Unable to fetch information about the error)(DBD:
dbd_db_login/SQLSetConnectOption err=-2) at
../testODBC.pl line 11.
-> DESTROY for DBD::ODBC::db
(DBI::db=HASH(0x81582d4)~INNER)
DESTROY for DBI::db=HASH(0x81582d4) ignored -
handle not initialised
<- DESTROY= undef
-- DBI::END
-> disconnect_all for DBD::ODBC::dr
(DBI::dr=HASH(0x8182b78)~0x8158388)
<- disconnect_all= '' at DBI.pm line 533
-> DESTROY in DBD::_::common for DBD::ODBC::dr
(DBI::dr=HASH(0x8158388)~INNER)
<- DESTROY= undef during global destruction
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
http://sports.yahoo.com
