Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

906607Dec 20 2011 — edited Dec 20 2011
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

Comments

unknown-7404 
What do I need to do, and how do I do it, so I can start coding?

If you search the forum you will find the question of how to troubleshoot that exception has been answered MANY time.

First you need to have a database to connect to.

Then you need to provide the proper connection information in the connection dialog. The information you provide depends on the type of connection you are trying to create (basic, tns, etcz).

Typically that exception is thrown when you don't provide the proper host, port or sid/service_name.

Post ALL of the details about the connection information you are entering. That includes the values of any dropdowns.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 17 2012
Added on Dec 20 2011
#oracle-provider-for-ole-db, #windows-and-net
0 comments
178 views