XP and IIS 5.1 error

Topic

New Reply

I have a asp file connection to Access database. I runs OK with IIS 5.0 and Win 2K. But when I run it on XP, it shows me the error below.

Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string
/database/index.asp, line 25

This is line 25

set conn = server.createobject(“adodb.connection”)

What’s wrong? Any idea?

TIA.
Tim K.

Reply | Quote

Replies

I found the error causes by ADO. How can I register ADO, ADOX.
I have mixed versions of them i.e.

Microsoft Active Data Objects 2.6 Library (msado26.tlb, 80 KB, 2.70.7713.0)
Microsoft ADO Ext. 2.7 for DDL and Security (msadox.dll, 176 KB, 2.70.7713.0 )
Microsoft Jet and Replication 2.6 Objects (msjro.dll, 88 KB, 2.70.7713.0 )

Any idea?
Tim K.

Reply | Quote

Find the name such of the control that is giving you the error it may have an OCX, TLB, DLL or OLB extension. Search your hard drive for variations of this name. Now go to VBA Click on Tools – References and browse for this file. When you find it click on it and register it.

This happens a lot when you do a clean install of Windows XP. It doesn’t seem to happen when you do an upgrade as often.

Reply | Quote

Thank you for your reply. I have downloaded MDAC 2.7 and installed it. Then I downloaded Jet40SP5 and installed it. Nothing improved.

When I tried with Access XP, it gave me this error message.

Run-time error ‘429’
ActiveX Component can’t create object

And it hilighted at this line of code.

cnn.Open “Provider=Microsoft.Jet.OLEDB.4.0;” _
& “Data Source=D:Program FilesMicrosoft OfficeOffice10Samplesnorthwind.mdb;”

What’s going on?

Tim K.

Reply | Quote

Your control has to be registered in program you are running. Press ALT+F11 to get to the VBA editor, then as I said earlier click on Tools then References, then Browse.

Find a name like the control you are running, there are probably more than one control by the name you are trying to use, and the current control that is registered isn’t working.

Reply | Quote