Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Windows and .NET
Oracle Provider for OLE DB
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Dec 20, 2011 5:32 PM by
Test Connection Successful but can't actually use OLE DB Provider....
Dec 20, 2011 5:32 PM
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.
# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.251)(PORT = 1521))
(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?
Edited by: 903604 on Dec 20, 2011 3:31 PM
This content has been marked as final.
Show 0 replies