Connection to Oracle failes
Hi!I have such a problem:On CompClient i have installed:Windows Server 2003 64-bit Ent.Ed.SQL Server 200564-bit Ent.Ed.Oracle Client 10.2.0.1.0.There is Oracle 9.2.0.6.0 on CompServer.Wheni try to make connection from CompClient to CompServer using SQLServer i get an error: An error occured during decryptionWheni 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:...Wheni 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 2 Drivers (SQL Native Client and SQL Server)...How can i solve this problem?Thank you for your time!Evgeniya
April 16th, 2009 8:52am

Hi, As this issue is mainly related to Oracle which is manufactured by a company independent of Microsoft, we are not the best resource to troubleshoot this third-party product issue. I suggest contacting Oracle for direct assistance. Oracle forum: http://forums.oracle.com/forums/main.jspa;jsessionid=8d92079030d6c3589a458f1546a3b9f58f4fde5c6f94.e38Qb3qMa3eRbO0LaNqQaNaPb3qSe0?categoryID=84 I hope your issue can be resolved soon. Tim Quan - MSFT
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2009 9:48am

Thank you for the answer. But I can connect to Oracle using Oracle Tools, but can not connect to Oracle using Microsoft Tools...Best regardsEvgeniya
April 16th, 2009 10:39am

You can also try Microsoft SQL Server forum: http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver Tim Quan - MSFT
Free Windows Admin Tool Kit Click here and download it now
April 16th, 2009 10:57am

Thank you!I thinkthe Problem iswith MDAC (Microsoft Data Access Components) because in Administrative Tools -> Data Sources (ODBC) -> Drivers there are no drivers i need..Thank you for your time!Evgeniya
April 16th, 2009 12:00pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics