This discussion is archived
0 Replies Latest reply: Dec 20, 2011 3:32 PM by 906607 RSS

Test Connection Successful but can't actually use OLE DB Provider....

906607 Newbie
Currently Being Moderated
I used Net Configuration Assistant to set up the tnsnames.ora, and tested the connection. It connects to the database. 100% great, fine. No problems.


When I try to use the OLE DB Provider, i get the world-famous ORA-12154 error. Please help, I spent all day on this and got absolutely nowhere.

My tnsnames.ora:
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ABC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.251)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = abc)
)
)

Not sure why I'm getting this error.....is there a special way to configure the OLE Provider?

I can run tnsping.exe (tnsping abc) and it works so i think TNS is set up correctly.
How to tell OLE Provider though?
Thank You

Edited by: 903604 on Dec 20, 2011 3:31 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points