set oConno = Server.CreateObject("ADODB.Connection")
set oRsMain = Server.CreateObject("ADODB.Recordset")
oConno.ConnectionString = "Provider=SQLOLEDB;Data Source=[servername];Initial Catalog=[database];User Id=[userid];Password=[password]"
I am very much glad with ur answer for my question.
But i dont know where to write this code??How to write?and how to connect ??And i dont what to fill in the spaces i.e., Brackets.
Could u please send me the entire code with full details and one more thing is that i created a web page with login form and register form but i dont know how to connect to the database and how to retrieve data and insert all these things Could u please tell all those details..i visited so many sites i am not able to under stand could u please let me know.