How to make connection .net with sqlserver

[kuldeep singh sethi]

Hi friends,

i am suffering with one problem. i am unable to make connectivity between .net 2003 and sqlserver. I want to make connection String with sqlserver. but not possible. i am a new learner of .net. Is there any problem with "web.config" file or others. For Example i have a login page and now i want to make sql server connection. Connection string is also making. but when i am running that application. then error message is showing. so plz send me all procedure.




Kuldeep singh sethi

[nmsreddi]

hello

first you got connected from code behind write connection string in your code (not in config) if its working then copy that to config file between appSetting tags

and refer that setting in your code behing by using cofiguration name space

and use configurationsettings.Appsetting[your connection string name]


try it out it works fine


regards

nmsreddy

[manishkumar]

Dim objCon as sqlConnection
objCon =new sqlConnection("SERVER=ebizserver;Database=KIML_PRO DDATA;UID=SA;PWD=;")

[radcaesar]

First tell Whats the Error u had got

:)

[kuldeep singh sethi]

Thanks!!!

But sir my question is that i have installed .net2003 and sqlserver 2003. but now the trouble is not to make connectivity between both. so pls guide me how can i do that.


Kuldeep singh sethi

[kuldeep singh sethi]

First tell Whats the Error u had got

:)

Thanks!!!

But sir my question is that i have installed .net2003 and sqlserver 2003. but now the trouble is not to make connectivity between both. so pls guide me how can i do that.


Kuldeep singh sethi

[kuldeep singh sethi]

Dim objCon as sqlConnection
objCon =new sqlConnection("SERVER=ebizserver;Database=KIML_PRO DDATA;UID=SA;PWD=;")

Thanks!!!

But sir my question is that i have installed .net2003 and sqlserver 2003. but now the trouble is not to make connectivity between both. so pls guide me how can i do that.


Kuldeep singh sethi

[kuldeep singh sethi]

hello

first you got connected from code behind write connection string in your code (not in config) if its working then copy that to config file between appSetting tags

and refer that setting in your code behing by using cofiguration name space

and use configurationsettings.Appsetting[your connection string name]


try it out it works fine


regards

nmsreddy

Thanks!!!

But sir my question is that i have installed .net2003 and sqlserver 2003. but now the trouble is not to make connectivity between both. so pls guide me how can i do that.


Kuldeep singh sethi