Can not connect to Oracle
696573Apr 16 2009 — edited Apr 21 2009Hi!
I have such a problem:
On CompClient i have installed:
Windows Server 2003 64-bit Ent.Ed.
SQL Server 2005 64-bit Ent.Ed.
Oracle Client 10.2.0.1.0.
There is Oracle 9.2.0.6.0 on CompServer.
When i try to make connection from CompClient to CompServer using SQLServer i get an error:
An error occured during decryption
When i try to make connection from CompClient to CompServer using Business Intell.Dev.Studio i get an error:
Test connection failed because of an error in intializing provider. ORA-12154. TNS:...
When i try to make connection from CompClient to CompServer using Oracle SQL*Plus it successes!
Tnsnames.ORA is confidured.
But in Administrative Tools -> Data Sources (ODBC) -> Drivers there are only 3 Drivers (SQL Native Client ,SQL Server and Oracle in OraClient10g_home2)...
How can i solve this problem?
Thank you for your time!
Evgeniya