Ginni Machamer 24.Jun.09 11:33 AM a Web browser LC LSX LC LSX - All Releases Windows
I have an agent that should connect to an Oracle db. Oracle 10g is installed on the server. The tnsnames.ora file on the server shows my connection as:
(ADDRESS = (PROTOCOL = TCP)(HOST = jadebpel.aero.org)(PORT = 1521))
(SERVICE_NAME = aeroinst.aero.org)
And my connection params in the agent are:
Dim ora_Connection As New LCConnection( "oracle" )
ora_Connection.Server = "aeroinst"
ora_Connection.UserID = "xxxx"
ora_Connection.Password = "xxxx"
This scenario is no different than that of another application, with the same type of agent, also connecting to Oracle, and that one works fine. I have the same type of settings in the tnsnames.ora file for that connection and the same type of param passing in its agent...
However, this agent returns the error:
ORA-12154: TNS:could not resolve the connect identifier specified, Connector 'oracle', Method -Connect- (12154) on line 52
Is it obvious to anyone else what I have wrong here???