I have a newly-installed machine running Win 2000 Pro, IIS 5.

I am trying to connect to an Access 2000 database but keep getting this message:

Server object error 'ASP 0177 : 800700c1'

Server.CreateObject Failed

/Develop/DBTest.asp, line 19

800700c1

The code is:

Dim adOpenForwardOnly, adLockReadOnly, adCmdTable
adOpenForwardOnly = 0
adLockReadOnly = 1
adCmdTable = 2

Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = Server.CreateObject("ADODB.Recordset")

objConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DBTest.mdb;Persist Security Info=False" 'this is line 19

IIS 5 is uncharted territory for me. so any help or suggestions will be gratefully received.


-------------------
System 3 2000 Limited
www.system3-2000.co.uk

__________________
-------------------
System 3 2000 Limited
www.system3-2000.co.uk (but very out-of-date!)

What version of the MDAC is on the machine?

I have to admit I am not sure, but it is whatever version is installed with Windows 2000 Pro. I have downloaded MDAC 2.8 from Microsoft but have not installed it yet.

Pat

-------------------
System 3 2000 Limited
www.system3-2000.co.uk

That error usually occurs because the component isn't installed, or the account doesn't have special permissions (like dcomcnfg for the office API). The latter doesn't apply for ADODB. I would try to install the MDAC and see if that fixes your problem. I don't know of any other error that may be... doesn't mean there isn't any....

Brian