I'm trying to connect to an Oracle database using SID. On Plex help:
Windows application
The details for each logical connection name must be specified in
- The INI file for a WinC client.
- The registry for a WinNTC C++ server application. Use the Environment Manager rather than editing the registry directly.
If the specified connection name cannot be found at run time, the name is assumed to the name of a DSN or SID. If no such DSN or SID exists, then no connection is made, and an error occurs.
[ODBC-CON: DBOne] DSN=My DSN Name Userid=Fred Password= Database= Errorlog=True Default Connect=True
[ORA-CON: DBTwo]SID=An Oracle Database Userid=Fred Password= Errorlog=True Default Connect=True
But by using the second method (SID instead of ODBC) I always obtain this error : ORA-12560: TNS Protocol adapter error. I haven't found any other help about this kind of connection. I've tried it in two different computers (testing first the SID connection with tnsping command) and obtain the same error.
Any help will be welcome!
Adolfo