i have used the following code on my website:
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open strCon
Set rsConfiguration = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblConfiguration.* From tblConfiguration;"
rsConfiguration.Open strSQL,strCon (this is line 152 in the script)
the error i get on executing the script says:
Provider error '80004005'
Unspecified error
line 152
what's wrong here - someone told me tht the connection has not been established successfully but he didnt know what to do
please help
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open strCon
Set rsConfiguration = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblConfiguration.* From tblConfiguration;"
rsConfiguration.Open strSQL,strCon (this is line 152 in the script)
the error i get on executing the script says:
Provider error '80004005'
Unspecified error
line 152
what's wrong here - someone told me tht the connection has not been established successfully but he didnt know what to do
please help