locked
ORA-12154: TNS: could not resolve the connect identifier specified RRS feed

  • Question

  • User-1716253493 posted

    I have operate oracle database very rarely. I have oracle 9i database at the server, long time a go i have link the database into ms access.

    Now, i have win8.1 and oracle client 11 installed. I try to link it again but always failed.

    I have done configure Local Net Service Name using Net Configuration Assistant (test result is OK)

    But when i try to configure ODBC, trying to link the data into MS Access i get error : 

    ORA-12154: TNS: could not resolve the connect identifier specified

    Can anyone help me to fix the problem please. Thanks

    Tuesday, August 19, 2014 10:59 PM

All replies

  • User269602965 posted

    DO not use ODBC in application

    Use ODP.NET using OracleDataAccess.dll to extract data from the link in Oracle to MS Acess.

    Thursday, August 28, 2014 3:01 PM