Re: :ODBC fails, SQL*Plus works

Scott Stansbury <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]> 
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, but in this case that is failing also. Configuring the DSN via the ODBC Data Source Administrator control panel and hitting "Test Connection" yields the same error:
	Unable to connect
	SQLState=08004
	[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified.

I added the connection parameters and credentials to the script to see if it was windows talking to the Oracle InstantClient ODBC layer that was causing the problem...


Scott...
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.