this is error ORA-12154 TNS could not resolve the connect identifier specified

Question

I ve this code    OracleConnection con   new OracleConnection  data source localhost user id fastecit password fastecit     con Open    string sql  Select userId from tblusers       OracleCommand cmd   new OracleCommand sql  con   OracleDataReader dr   cmd ExecuteReader    while  dr Read      messageBox Show dr 0  Tostring          Same code in both projects   in project1  WinForm  Is Working correctly  in project2  Excel 2007 addins  Following error appears      ORA-12154  TNS could not resolve the connect identifier specified   I m using C  net 2010  office 2007   windows8  oracle 10g   When preparing a manual connection to the database  as shown in the picture  Visual Studio  open View menu   Server Explorer   Right mouse click on Data Connection   Add Connection   Select Oracle Database server Name   localhost or name of my machine  set username  amp  password and click on Test Connection  test is  no succeeds

User · Answer

run the below command in command prompt

tnsping Datasource

This should give a response like below

C:>tnsping *******

TNS Ping Utility for *** Windows: Version *** - Production on *****

Used parameter files: c:\oracle*****

Used **** to resolve the alias Attempting to contact (description=(address_list=(address=(protocol=tcp)(host=)(port=)))(connect_data=(server=)(service_name=)(failover_mode=(type=)(method=)(retries=)(delay=))))** OK (**** msec)

Add the text 'Datasource=' in beginning and credentials at the end. the final string should be

Data Source=(description=(address_list=(address=(protocol=tcp)(host=)(port=)))(connect_data=(server=)(service_name=)(failover_mode=(type=)(method=)(retries=)(delay=))));User Id=;Password=;**

Use this as the connection string to connect to oracle db.

User · Answer

The database must have a name  example DB1   try this one   OracleConnection con   new OracleConnection  data source DB1 user id fastecit password fastecit       In case the TNS is not defined you can also try this one   OracleConnection con   new OracleConnection  Data Source  DESCRIPTION  ADDRESS LIST  ADDRESS  PROTOCOL TCP  HOST localhost  PORT 1521    CONNECT DATA  SERVER DEDICATED  SERVICE NAME DB1     User Id fastecit Password fastecit

User · Answer

ORA-12154  TNS could not resolve the connect identifier specified   In case the TNS is not defined you can also try this one   If you are using C  net 2010 or other version of VS and oracle 10g express edition or lower version  and you make a connection string like this   static string constr     Data Source  DESCRIPTION       ADDRESS LIST  ADDRESS  PROTOCOL TCP  HOST yourhostname   PORT 1521         CONNECT DATA  SERVER DEDICATED  SERVICE NAME XE         User Id system  Password yourpasswrd      After that you get error message ORA-12154  TNS could not resolve the connect identifier specified then first you have to do restart your system and run your project   And if Your windows is 64 bit then you need to install oracle 11g 32 bit and if you installed 11g 64 bit then you need to Install Oracle 11g Oracle Data Access Components  ODAC  with Oracle Developer Tools for Visual Studio version 11 2 0 1 2 or later from OTN and check it in Oracle Universal Installer Please be sure that the following are checked   Oracle Data Provider for  NET 2 0  Oracle Providers for ASP NET  Oracle Developer Tools for Visual Studio  Oracle Instant Client    And then restart your Visual Studio and then run your project      NOTE - SYSTEM RESTART IS necessary TO SOLVE THIS TYPES OF ERROR

[c#] this is error ORA-12154: TNS:could not resolve the connect identifier specified?

Examples related to c#

Examples related to oracle

Examples related to excel-addins