Server.CreateObject error

[simplyblue]

Hi all!
I kept getting this error on pages which access my Access database

Server object error 'ASP 0177 : 80004005'

Server.CreateObject Failed

/test/db.asp, line 25

80004005


I didn't have any problems when i try the codes out on another computer or server. I just installed PWS on this computer. Must I install anything else for my database connection to work?

Thanks.

[oracleguy]

Could you post the code?

Also this other computer, is it using PWS or is it using IIS?

The error may be caused if you don't have the driver on your computer and the other one does. In driver I mean the ODBC driver like in this example:

DataConn.Open "DBQ=" & Server.MapPath("dynamics.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;", "username", "password"


You can use either this driver or the JET driver. There maybe others but those are the only two i use if I'm using an access database.

I'm also not too familiar with PWS, so something else may be to blame.

[simplyblue]

This is where I try to get a database connection

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("database/forum.mdb")

Set dbc = Server.CreateObject("ADODB.Connection")
dbc.open strConn

I tested out the codes on another computer, with PWS.

How do I install the jet driver or something?