I get this error on my page:
error '80004005'
/main.asp, line 68
i recently changed the table structure of my database and changed my SQL strings to match them. when i uploaded the page and the database i got the above error. I have set full permissoins on my database this is the code snippet:
<%
'set DB properties and connections
Server.ScriptTimeout = 90
Session.Timeout = 20
Session.LCID = 1033
Set adoCon = Server.CreateObject("ADODB.Connection")
strDBPath = Server.MapPath("*****.db")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDBPath
adoCon.connectionstring = strCon
adoCon.Open
Set rsCommon = Server.CreateObject("ADODB.Recordset")
'open DB and count number of articles in tblArticles
strSQL = "SELECT Count(ID) AS countAll "
strSQL = strSQL & "FROM gfaith "
strSQL = strSQL & "WHERE Section='" & strSection & "';"
rsCommon.Open strSQL, adocon
intCount = CInt(rsCommon("countAll"))
rsCommon.Close
>%