SQLServerCentral / SQL Server 2008 / Working with Oracle / where to find dbservername when connecting to oracle from asp.net / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 11:37:26 GMT20RE: where to find dbservername when connecting to oracle from asp.nethttp://www.sqlservercentral.com/Forums/Topic1409269-1044-1.aspxdb 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)Mon, 21 Jan 2013 00:05:38 GMTJo Pattynwhere to find dbservername when connecting to oracle from asp.nethttp://www.sqlservercentral.com/Forums/Topic1409269-1044-1.aspxhello 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[code="vb"]<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>[/code]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?Sun, 20 Jan 2013 05:44:03 GMTlamiajoyee