George Fisherman
George Fisherman

Reputation: 41

error ora-12154 tns could not resolve the connect identifier specified access 2010

I'm trying to connect to Oracle database through Access 2010 using Microsoft ODBC and linking the database tables, unfortunately Access shows that cannot connect to database:

Things that i done:

But at momment to select the database Access shows the Error ora-12154 tns could not resolve the connect identifier specified

Upvotes: 1

Views: 1122

Answers (1)

George Fisherman
George Fisherman

Reputation: 41

The last thing that i tried it was copy the ms Access Folder located in C:\Program Files (x86)\Microsoft Office\Office14 to the folder C:\Program Files\Microsoft Office\Office14\Office14,note the diference in Program Files (x86) to Program Files, and opening access from the folder ubicated in program files, and successfully the application recognizes the odbc driver and connection.

Upvotes: 0

Related Questions