Assigning Oracle Connections with DTS Global Variables Not Working -
10-09-2006
, 09:12 PM
I'm passing in a global variable representing the Oracle ODBC
Connection name. However, I don't believe it's being passed to the MS
Oracle ODBC Server Connection Property. If I change the global
variable manually and hard code it and execute, it works correctly.
However, if I set it from my connections entity and execute it, it
doesn't succeed. The error that it thrown is:
REPORTED ERROR: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154:
TNS:could not resolve service name
Any ideas? |