ASP Forum
Error 8004005 revisited
webdesign | Posted 8:23am 23. September 2007 Server Time |

So I am working on this....  Tried to break it down some more.

I am using this on top of the page.

Dim Conn,rs,sSql
Set Conn = server.createobject("ADODB.connection")
Conn.provider="Microsoft.Jet.OLEDB.4.0"    
Conn.Open(Server.Mappath("yourdatabase.mdb"))
set rs = Server.CreateObject("adodb.RecordSet")
sSQL = "Select * from yourdatabase"
rs.Open sSql, Conn, 3  

This works fine .... but when I try to use another database on the same page with the same code....I come up with the 8004005 error.

Dim Connx,rsx,sSqlx
Set Connx = server.createobject("ADODB.connection")
Connx.provider="Microsoft.Jet.OLEDB.4.0"    
Connx.Open(Server.Mappath("otherdatabase.mdb"))
set rsx = Server.CreateObject("adodb.RecordSet")
sSQLx = "Select * from otherdatabase"
rsx.Open sSqlx, Connx, 3  


never had a problem with my website before.  It had been working fine for over a year.  I haven't made changes.

I could offer a cash reward for you help on this.  I do have Paypal and want to get my site running again.

Thanks
katy8439 | Posted 3:12am 24. September 2007 Server Time |

It could be a permissions problem. Check that you have read/write access on the database folder....
webdesign | Posted 6:07am 24. September 2007 Server Time |

Permissions are read and write ....

please help
katy8439 | Posted 7:49am 24. September 2007 Server Time |

What are the field names in the new table you're trying to access - are you using any reserved words?
webdesign | Posted 10:38am 24. September 2007 Server Time |

The name of the table I am trying to access has been in place for over a year.  I don't think that is the problem.

Anyone wishing to help me out.  I can have you log in to my domain portal to see what could be the problem.

devlin1044@yahoo.com

Please include in subject title: (ALL CAPS) "HANENG 80004005"

Thanks
webdesign | Posted 5:33am 4. October 2007 Server Time |

This is the email I got from customer support.......

We apologize for any inconvenience this has caused you. We have switched the DNS hence your Web site http://www.yoursite.com is down and not working. This is the reason you were unable to access the Web site. It is a temporary issue and now it will be resolved. You will be able to access it within a couple of days.

question..............
Is this enough to mess up asp code?


Reply to Post Error 8004005 revisited



Back to Forum Page