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 (0x800A01AD) ActiveX component can't create object: 'ADODB.Connections'

  • 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:
    46
  • Date Created
    Friday, November 19, 2010
  • Last Updated
    Friday, November 19, 2010
  • This Article Has been Viewed
    3072 times
  • Short Desc
    Creating the Connection the Server Object for your connection string, sometimes you may misspell the Connection with Connections. This will cause a VBScript runtime error.
  • Details
    When creating the connection ServerObject, you sometimes might misspell the Connection(s) name. If you do, this is the error you will receive.

     
    Microsoft VBScript runtime (0x800A01AD)
    ActiveX component can't create object: 'ADODB.Connections'
    /ACN.asp, line 7


    This error will only happen when you use CreateObject instead of Server.CreateObject. (View related Articles below)
  • Recreate Issue
    To recreate the error

    set cn = CreateObject("ADODB.Connections")

    Notice that the ADODB.Connections
    There is not suppose to be an (s) at the end of Connection
  • Resolve Issue
    to properly write out the connection object.

    set cn = CreateObject("ADODB.Connection")

    Notice that there is no s at the end of Connection


    --------
    Related Articles
    Server object, ASP 0177 (0x800401F3) Invalid class string«