Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XP and IIS 5.1 error

    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.
    <font color=red>
    Error Type:
    Server object, ASP 0177 (0x800401F3)
    Invalid class string
    /database/index.asp, line 25
    </font color=red>
    This is line 25
    <font color=448800>
    set conn = server.createobject("adodb.connection")
    </font color=448800>
    What's wrong? Any idea?

    TIA.
    Tim K.

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    More info added

    I found the error causes by ADO. How can I register ADO, ADOX.
    I have mixed versions of them i.e.
    <font color=blue>
    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 )
    </font color=blue>
    Any idea?
    Tim K.

  3. #3
    New Lounger
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More info added

    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.

  4. #4
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More info added

    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.
    <font color=red>
    Run-time error '429'
    ActiveX Component can't create object
    </font color=red>
    And it hilighted at this line of code.
    <font color=blue>
    cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _
    & "Data Source=D:Program FilesMicrosoft OfficeOffice10Samplesnorthwind.mdb;"
    </font color=blue>
    What's going on?

    Tim K.

  5. #5
    New Lounger
    Join Date
    Jun 2001
    Location
    Oklahoma
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: More info added

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •