none
Problem in creating the ADODB.Connection object Error Number returned:-2147024770 RRS feed

  • Question

  • Hi,

    We are migrating our applications from Windows 2003 to 2008 application server. We have vbs script in a job which is invoked from Tivoli Workload Scheduler (Windows)/JOBLNCH 8.5.1. We are getting the error while creating ADOBD object (Error Number returned:-2147024770). The error does not occur when we directly run the job on the 2008 server, but only when invoked throught the TWS scheduler. Also, this error is not occurring on 2003 server when run through the TWS.

    Here is the code snippet used to create object.

    set oSrcConnect = CreateObject("ADODB.Connection")

    Could you please help us identify if any settings need to be changed to avoid this error. Many Thanks for looking into the question.

    Monday, February 3, 2014 8:30 PM

Answers

  • Below steps seem to have fixed the issue:

    1) Provide the path of the folder C:\Program Files (x86)\Common Files\System\ado in the jobmanc of the maestro server.

    2) Create a folder C:\Windows\System32\config\systemprofile\Desktop (Maestro uses this folder)
    Tuesday, February 25, 2014 5:27 PM

All replies

  • My guess is that you need to run the script using the 32-bit script host (C:\Windows\SysWOW64\cscript.exe or C:\Windows\SysWOW64\wscript.exe).

    Bill

    Monday, February 3, 2014 8:35 PM
    Moderator
  • Hi Bill,

    Thanks for the quick reply, we did try that, but it did not work, we are still getting the same error.

    we tried using both cscript and wscript 32 bit versions.

    Monday, February 3, 2014 8:38 PM
  • Hi,

    Error -2147024770 = hex 8007007E

    Least significant 32 bits are hex 7E = decimal 126


    C:\>net helpmsg 126
    
    The specified module could not be found.
    

    This usually indicates that the COM object you're using is trying to load a DLL that is not installed.

    Based on only this error message, there's no way we can tell you how to fix your script.

    Bill

    Monday, February 3, 2014 9:09 PM
    Moderator
  • This can be because you have installed the wrong version of ADO on WS2008.

    Because this only happens under Tivoli you need to contact Tivoli to learn why.


    ¯\_(ツ)_/¯

    Tuesday, February 4, 2014 12:19 AM
  • Below steps seem to have fixed the issue:

    1) Provide the path of the folder C:\Program Files (x86)\Common Files\System\ado in the jobmanc of the maestro server.

    2) Create a folder C:\Windows\System32\config\systemprofile\Desktop (Maestro uses this folder)
    Tuesday, February 25, 2014 5:27 PM
  • This had nothing to do with scripting, but glad you found an answer.

    Bill

    Tuesday, February 25, 2014 5:45 PM
    Moderator
  • Below steps seem to have fixed the issue:

    1) Provide the path of the folder C:\Program Files (x86)\Common Files\System\ado in the jobmanc of the maestro server.

    2) Create a folder C:\Windows\System32\config\systemprofile\Desktop (Maestro uses this folder)

    This would be true if you were running this under the system account.  It is not true if you run under a user account.


    ¯\_(ツ)_/¯

    Tuesday, February 25, 2014 6:33 PM