ASP. NET and Oracle connection strings

ASP. NET and Oracle connection strings

Connectionstring= "PASSWORD=CZH; User id=czh;data source= (description= (address_list= (address=) (PROTOCOL=TCP) (host=192.168.168.211)) ( Connect_data= (server=dedicated) (Service_name=skydream))); "

HOST: Server IP or server name

Service_name:oracle Data Name

User Id:oracle username

Password:oracle User Password

If the Oracle database and the Web can be written on the same server

Connectionstring= "PASSWORD=CZH; User id=czh;data Source=skydream; "

You can also view the configuration file in C:\oracle\ora92\network\admin\tnsnames.ora (under the Oracle installation directory)

Reference Source: http://www.cnblogs.com/chinafine/articles/1835992.html

ASP. NET and Oracle connection strings