I am developing an application in Classic ASP
My database is SQLSErver 2008
I am getting a problem in connecting to my database.
Here is the code which i used to connect.
connstring ="server=mymsever;database=mydb;Trusted_Connection=Yes;" set conntemp = server.createobject("ADODB.Connection") conntemp.ConnectionString=connstring conntemp.Open() Response.Write(conntemp.State)
The last statement is for the confirmation that is my connection status open or not. But each time i get 0 as printed which means its closed.
What to do in this case. How to connect it.