RE: :ODBC fails, SQL*Plus works

2011-10-07 Thread Nelson, Erick [HDS]
annoying. DBI-trace($trace_level) DBI-trace($trace_level, $trace_filename) -Original Message- From: Scott Stansbury [mailto:sstansb...@aol.com] Sent: Wednesday, October 05, 2011 9:22 AM To: Nelson, Erick [HDS] Cc: dbi-users@perl.org Subject: Re: :ODBC fails, SQL*Plus works I'm sorry

RE: :ODBC fails, SQL*Plus works

2011-10-07 Thread Kong, Alan
] Sent: Wednesday, October 05, 2011 12:22 PM To: Nelson, Erick [HDS] Cc: dbi-users@perl.org Subject: Re: :ODBC fails, SQL*Plus works I'm sorry - that was just fat fingers on the cut/paste... In actuality it is $oracle_host = 192.168.15.200:1535 On Oct 5, 2011, at 12:13 PM, Nelson, Erick [HDS] wrote

RE: :ODBC fails, SQL*Plus works

2011-10-07 Thread Kong, Alan
characters. What I am usually do is to type the tnsnames.ora entry manually, it should fix your problem. Hope this is the case. Alan From: Scott Stansbury [mailto:sstansb...@aol.com] Sent: Wednesday, October 05, 2011 1:17 PM To: Kong, Alan Cc: dbi-users@perl.org Subject: Re: :ODBC fails

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
I'm sorry - that was just fat fingers on the cut/paste... In actuality it is $oracle_host = 192.168.15.200:1535 On Oct 5, 2011, at 12:13 PM, Nelson, Erick [HDS] wrote: Your $oracle_host Perl var looks like it has more that just the host ip address and port in it. What is the 10.128 ?

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread tiger peng
sstansb...@aol.com To: Nelson, Erick [HDS] erick.nel...@hdsupply.com Cc: dbi-users@perl.org Sent: Wednesday, October 5, 2011 11:22 AM Subject: Re: :ODBC fails, SQL*Plus works I'm sorry - that was just fat fingers on the cut/paste... In actuality it is $oracle_host = 192.168.15.200:1535 On Oct 5, 2011

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
On Oct 5, 2011, at 1:00 PM, Kong, Alan wrote: Since you are using DBI::ODBC, you should create an ODBC data source pointing to your Oracle database first, and then calling the connect function by passing the data source name you just created for ODBC data source. That's our standard config,

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Scott Stansbury
On Oct 5, 2011, at 1:47 PM, Kong, Alan wrote: It is different than typing the whole connection description in the command prompt as it will bypass tnsnames.ora entry. ODBC is looking for the tnsnames.ora entry for connection description, so using the above connection method, I bet it will

Re: :ODBC fails, SQL*Plus works

2011-10-05 Thread Bill Ward
, October 5, 2011 11:22 AM Subject: Re: :ODBC fails, SQL*Plus works I'm sorry - that was just fat fingers on the cut/paste... In actuality it is $oracle_host = 192.168.15.200:1535 On Oct 5, 2011, at 12:13 PM, Nelson, Erick [HDS] wrote: Your $oracle_host Perl var looks like it has more