CODEWITHSUNDEEP
c#databaseoracle-databaseconnection-stringtnsnames
David
David

Reputation: 4508

connect to oracle DB using TnsNames Alias

In my TnsNamesOra I have

TEST11.12.13.14 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.13.14)(PORT = 1234))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TESTNAME)
    )
  )

If my connection string looks like this:

Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.12.13.14)(PORT = 1234)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = TEST))); User Id = admin; Password = admin ; DBA Privilege = SYSDBA ; Pooling = false; Connection Timeout = 30" providerName="Oracle.DataAccess.Client

Everything works fine.

But I want to do something like this:

Data Source = TEST11.12.13.14; User Id = admin; Password = admin ; DBA Privilege = SYSDBA ; Pooling = false; Connection Timeout = 30" providerName="Oracle.DataAccess.Client

But getting error

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

Upvotes: 2

Views: 2090

Answers (0)

Related Questions