locked
Could not Connect to Oracle10g while using Oracle11g client RRS feed

  • Question

  • User322963126 posted

    Hai,

    In my application I am using Oracle10g with Oracle11g client. But I face the following exception while connecting to database.

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

    I could connect database with system.Data.OracleClient. But while using 11g client, I face connection problem,

    Is this due to server version problem? or should I change my tnsnames.ora file.

    Any changes should be made in web.config file

    Help me resolving this.

    Thanks,

    Viknesh.A

    Friday, August 19, 2011 2:04 AM

All replies

  • User551462331 posted

    u can use 11g client with oracle 10g DB.

    it seems u r missing connection details in tnsnames.ora file...

    or, if u earlier had 10g client and then installed 11g client, then there could be two oracle folders on your machine..... and u might be looking at wrong tnsnames.ora file while actual tnsnames file which is being used by oracle client is diffrent which is missing connection details....

    u can search for tnsnames.ora file on your machine and see if there are multiples of it...

    for more info

    http://ora-12154.ora-code.com/

    http://www.orafaq.com/wiki/Tnsnames.ora

    hope this helps....

    Friday, August 19, 2011 2:23 AM