Connection string web.config file
-
Hi, I've created a web portal and i am planning to host it. I am using AsP.NET 2005 and SQL SERVER 2000 and my problem is that: I want to know how to set the connection string in web.config file ,to be accessed by the application in a remote webserver (in the case of local connection it's OK) Plz help me out. Thankx in Advance !!
-
Hi, I've created a web portal and i am planning to host it. I am using AsP.NET 2005 and SQL SERVER 2000 and my problem is that: I want to know how to set the connection string in web.config file ,to be accessed by the application in a remote webserver (in the case of local connection it's OK) Plz help me out. Thankx in Advance !!
Hi, In web.config file ,put the server credentials in the connection string...
S Kumar
-
Hi, In web.config file ,put the server credentials in the connection string...
S Kumar
cud plz get me one example .
-
cud plz get me one example .
sample here: add name="MapsaLoanConnectionString" connectionstring="Data Source=192.168.0.220;Initial Catalog=Mapsa;Persist Security Info=True;User ID=databaseUser;Password=123" providername="System.Data.SqlClient"
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
-
sample here: add name="MapsaLoanConnectionString" connectionstring="Data Source=192.168.0.220;Initial Catalog=Mapsa;Persist Security Info=True;User ID=databaseUser;Password=123" providername="System.Data.SqlClient"
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
thanx ! but i wud like to get the DataSource to be autodetected by the code not with IP Address
-
thanx ! but i wud like to get the DataSource to be autodetected by the code not with IP Address
Hi, you can also use different connections at the runtime ,just you have to declare your connection string at runtime ie; in .vb or .cs file
S Kumar