ORA-12560
Hello,
i'm working on Windows2003-Server and installed oracle full client to connect to an Oracle-DB 11g on Unix.
I can connect using SQL-Plus but not with Oracle Ole DB. The programs i use, are C#-Programs with NET-Version 2.0.
The connection string i use in the program is "Provider=OraOLEDB.Oracle;Persist Security Info=False;Password=xxx;User ID=XXX; DataSource=vgdb;Extended Properties=".
I tried several connection strings, but i always get the error ORA-12560.
This connection-string works already on other machine. But here its a fully installation of oracle database 10g on windows and i can also connect from here to Oracle-DB 11g on Unix.
Configuration of sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
ADR_BASE = O:\app\admin\product\11.2.0\client_1\log
Entry in tnsnames.ora:
vgdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.156.199)(PORT = 1523))
)
(CONNECT_DATA =
(SID = svgdb)
)
)