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...