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
|