none
.NET Runtime 2.0 Error Event ID 5000 clr20r3 system.data.oracleclient.oracle RRS feed

  • Question

  • Hi All,

        We are running a vb.net windows based application that works perfectly throughout the state, with the exception of a few locations that are designed differently(run apps from the server) and the application runs(opens for viewing), but does not connect to the database and gives  an error that it cannot connect to the database: ORA:12154 TNS: could not resolve service name.  Since none of the window fields are populated with data, we can assume data is not being pulled from the database, but why?   Thanks in advance for any assistance.

    Thursday, May 22, 2008 8:59 PM

Answers

  • Hi

     

    ORA:12154 error is returned by the oracle native driver. It means that the connect identifier used by you application could not be resolved into a connect descriptor on the computer that this code is executing on. Usually, it means the oracle driver cannot find the entry in the tnsnames.ora configuration file.

     

    For troubleshooting this error, please refer to Oracle's documentation. For example, take a look at: http://ora-12154.ora-code.com/ for possible solutions. If you have distributed application, make sure that the data source TNS name you use is valid on every computer that uses this name.

     

    If the above tips do not help, please specify more details: the code you are running, data source you are using, relevant entry in tnsnames.ora, and more information that can be useful in investigation of this issue.

     

    Regards,

     Nissim

    Sunday, May 25, 2008 1:00 AM
    Moderator

All replies

  • Hi

     

    ORA:12154 error is returned by the oracle native driver. It means that the connect identifier used by you application could not be resolved into a connect descriptor on the computer that this code is executing on. Usually, it means the oracle driver cannot find the entry in the tnsnames.ora configuration file.

     

    For troubleshooting this error, please refer to Oracle's documentation. For example, take a look at: http://ora-12154.ora-code.com/ for possible solutions. If you have distributed application, make sure that the data source TNS name you use is valid on every computer that uses this name.

     

    If the above tips do not help, please specify more details: the code you are running, data source you are using, relevant entry in tnsnames.ora, and more information that can be useful in investigation of this issue.

     

    Regards,

     Nissim

    Sunday, May 25, 2008 1:00 AM
    Moderator
  • Thanks.  The problem was the wrong tnsnames file.

     

    Tuesday, May 27, 2008 8:20 PM