CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:
  • Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'ADODB'

  • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    139
  • Date Created
    Thursday, June 23, 2011
  • This Article Has been Viewed
    2509 times
  • Short Desc
    When you create an Object, you must make sure that you have the object and command written out properly, If not, you will receive the VBScript runtime error '800a01ad' ActiveX component can't create object.
  • Details
    When you write out the CreateObject, you must make sure that you write it out correctly and have every part of the line intact, if not you will receive the following error.

     
    Microsoft VBScript runtime error '800a01ad'
    ActiveX component can't create object: 'ADODB'
    /sqlMenu.asp, line 15


  • Recreate Issue
    To recreate this issue.

    <%
    set CatCt = CreateObject("ADODB")
    %>


    As you can see in the above line, we have left out the COMMAND at the end of the ADODB.
  • Resolve Issue
    To resolve this issue.

    <%
    set CatCt = CreateObject("ADODB.Command")
    %>


    As you can see in the above line, we have added in the COMMAND at the end of the ADODB.
    Which is the correct way of writting out this line.
    In order to Create and Object, you have to implement the Command.
    As we have done here.