dreded error 80004005 [Archive]

Click to See Complete Forum and Search --> : dreded error 80004005

lcscne

04-01-2004, 09:43 AM

This is crazy. I'm all of the sudden getting this stupid 80004005 error. The only change I've made to the file system was creating a new Access file in the same folder as an already existing file and now I can access the new one but not the old. I've read all the TIDs about permissions and that’s not the case here as I said I can access the new Access db but not the old one. Does anyone have any late breaking news on this error? I've read some TIDs where people have upgraded their servers to take care of this problem; I don't have that luxury as I'm running Windows2003 WE.:mad:

the error comes when I try to open the recordset

rsMovie.Open strSQL, objConn

lcscne

04-01-2004, 11:40 AM

I read a TID where someone was getting 80004005 errors because he had a field named 'open' an obvious reserved word. He renamed the field to something else and fixed his issue. Would someone be willing to create an Access db with a table named 'cast' and run the following code against it and see if you can dupe my problem? Then rename the 'cast' table to 'tblcast' , update the ASP and see if that has an effect? much appreciated to whoever is willing.

<%Option Explicit%>
<%
Dim objConn, StrConnect

Strconnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\datastores\justin\Movie2000.mdb;" & _
"Persist Security Info = False"
Set objConn = Server.Createobject("ADODB.Connection")
objConn.Open strconnect
%>

<html>
<head>
<title>find director</title>
</head>

<body>
<%
dim objrs

Set objRS = server.createobject ("ADODB.Recordset")
objRS.open "Cast", strConnect, 0, 1, &H0002

If Not objRS.EOF Then
objRS.MoveFirst
End If

objRS.close
set objrs = nothing
objconn.close
set objconn = nothing
%>
</body>
</html>

lcscne

04-01-2004, 11:59 AM

to you moderator dudes,
when all troubleshooting fails on this 80004005 error - keep this in mind, that the table and field names of the backend need to shove clear of any keywords (bethey known or unknown).

In my case I found cast (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp) to be an SQL function that was causing my 80004005 error.

I pitty gccwebmaster and what he had to do to get resolution to what may have been a table or field rename issue.

Originally posted by gccwebmaster
Alright, here's my final comments...

I tried my files on a 2000 Server running IIS 5 and everything works like a charm.

Solution: Upgrade the server :)

Thanks everyone for your help.

taken from TID (http://forums.webdeveloper.com/showthread.php?s=&threadid=25997&perpage=15&pagenumber=2)

buntine

04-01-2004, 12:04 PM

Thanks for the info, mate.

I would have helped you out, though, im not on my development machine so i havent got my server running.

Regards.