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
>%

that is the full error. nothing mroe specific than that appears.

line 68 is "rsCommon.open strSQL, adoCon"

sorry i didn't identify line 68 earlier. the page is http://www.gentlefaith.com/main.asp?section=articles - http://www.gentlefaith.com/main.asp?section=articles

in the querystring, 'section' is read into strSection

Usually an 80004005 error has more info. Typically it means something can't be accessed or can't be found.

Toss in a couple of response.writes to verify strCon and strSQL. You may also want to take a look at what's in strSection to ensure that no special characters are in there that might screw up the SQL.

PROBLEM SOLVED!

i guess the word Section is a reserved word wither in SQL or VBScript or something. it did not like that my field was named 'Section' and resulted in the error that i got. i changed it to a new name and it works fine now