Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^4: DBD::ODBC to Teradata

by DanEllison (Beadle)
on Nov 08, 2010 at 23:57 UTC ( #870217=note: print w/ replies, xml ) Need Help??


in reply to Re^3: DBD::ODBC to Teradata
in thread DBD::ODBC to Teradata

I made the changes you suggested and got a little more output, but I'm not sure what this telling me... except is this showing a failure before trying to set autocommit, possibly on a dead connection?

delli28@apsa9012:/u/delli28> test.pl DBI 1.615-ithread default trace level set to 0x6000000/15 (pid 888 +884 pi 20009e68) at test.pl line 8 -> DBI->connect(dbi:ODBC:nhitest, delli28, ****, HASH(0x2000ab38)) -> DBI->install_driver(ODBC) for aix perl=5.008008 pid=888884 ruid +=43679 euid=43679 install_driver: DBD::ODBC version 1.25 loaded from /u/delli28/l +ib/site_perl/5.8.8/aix-thread-multi/DBD/ODBC.pm New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x2052e7d4)=>DBI::dr=HASH(0x2052d27 +c), DBD::ODBC::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#20009e68 dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), Err, Null!) SCALAR(0x2 +0411574) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), State, Null!) SCALAR(0 +x204115bc) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), Errstr, Null!) SCALAR( +0x20411598) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), TraceLevel, Null!) 0 ( +already defined) dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), FetchHashKeyName, Null +!) 'NAME' (already defined) install_method DBI::st::odbc_lob_read <- install_driver= DBI::dr=HASH(0x2052e7d4) >> connect DISPATCH (DBI::dr=HASH(0x2052e7d4) rc2/3 @5 g0 ima8 +001 pid#888884) at /u/delli28/lib/site_perl/5.8.8/aix-thread-multi/DB +I.pm line 665 !! warn: 0 CLEARED by call to connect method -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x2052e7d4)~0x2052d27c +'nhitest' 'delli28' **** HASH(0x2025d028)) thr#20009e68 New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x2052d27c), + id=undef) dbih_setup_handle(DBI::db=HASH(0x2052ebdc)=>DBI::db=HASH(0x2052eb4 +0), DBD::ODBC::db, 204a3608, Null!) dbih_make_com(DBI::dr=HASH(0x2052d27c), 205342f8, DBD::ODBC::db, 4 +48, 0) thr#20009e68 dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Err, DBI::dr=HASH(0x20 +52d27c)) SCALAR(0x204a3794) (already defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), State, DBI::dr=HASH(0x +2052d27c)) SCALAR(0x204a37f4) (already defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Errstr, DBI::dr=HASH(0 +x2052d27c)) SCALAR(0x204a37c4) (already defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), TraceLevel, DBI::dr=HA +SH(0x2052d27c)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), FetchHashKeyName, DBI: +:dr=HASH(0x2052d27c)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), HandleSetErr, DBI::dr= +HASH(0x2052d27c)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), HandleError, DBI::dr=H +ASH(0x2052d27c)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), ReadOnly, DBI::dr=HASH +(0x2052d27c)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Profile, DBI::dr=HASH( +0x2052d27c)) undef (not defined) non-Unicode login6 dbd_db_login6 !!dbd_error2(err_rc=0, what=db_login/SQLAllocHandle(env), handles= +(0,0,0) SQLDriverConnect 'nhitest', 'delli28', 'xxxx' SQLDriverConnect failed: SQLConnect 'nhitest', 'delli28' Turning autocommit on Illegal instruction delli28@apsa9012:/u/delli28>


Comment on Re^4: DBD::ODBC to Teradata
Download Code
Replies are listed 'Best First'.
Re^5: DBD::ODBC to Teradata
by kcott (Abbot) on Nov 09, 2010 at 01:27 UTC

    Both the README and the FAQ (re connection problems) stress the importance of testing drivers, configuration and so on. So it's worth double checking those aspects.

    Googling: SQLDriverConnect failed AIX Teradata produced quite a few hits which may be of use.

    You have the latest DBD::ODBC version (1.25). There's a more recent development version (1.26_1) which you could try (although I didn't see anything in its Changes file which appeared to address your issue).

    If none of that works I'd raise a bug report.

    -- Ken

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://870217]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (13)
As of 2015-07-07 19:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (93 votes), past polls