where to find dbservername when connecting to oracle from asp.net

• lamiajoyee

  SSC Journeyman

  Points: 94

  More actions

  January 20, 2013 at 5:44 am

  #268840

  hello i have a rather novice question but i cant figure it out myself. when i try to modify web.config file i put a connectionstring like this

  <add name="ConnStr"

  connectionString="Data Source=<DB ServerName>;User ID=<SchemaName/UserName>;Password=<Password>;Persist Security Info=True;Connection Lifetime=10" providerName="System.Data.OracleClient"></add>

  what is 'DB ServerName' here?

  also when i try to connect via server explorer i get this message "ORA 12560 TNS: Protocol Adapter Error" but i have oracle connected via sqlplus.

  what can i do with these issues?

• Jo Pattyn

  SSC-Dedicated

  Points: 32066

  More actions

  January 21, 2013 at 12:05 am

  #1579091

  db servername would be the tns-alias, which is described further in tnsnames.ora.

  Like mydb. In tnsnames.ora Mydb= (connection info.... tcp....port....) (see the web for the actual connectionstrings)