Troubleshooting
Problem
A VBScript working fine in Windows CMD window fails with "ADODB. Connection: Provider cannot be found. It may not be properly installed" error in DataStage.
Symptom
Developed a VBScript to process an Excel file, and verified it's working fine in CMD window using cscript.exe command. Then ran the same cscript command in DataStage Before-job subroutine or Execute Command Activity, this time it failed with next error.
Item #: 39
Event ID: 38
Timestamp: 2016-06-29 11:03:06
Type: Info
User Name: WINBOX|dsadm
Message Id: IIS-DSTAGE-RUN-I-0019
Message: Test_vbs..JobControl (@ExecCmd_Test): Executed:
C:\Windows\System32\cscript.exe Test.vbs data.xlsx
Reply=0
Output from command ====>
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.
Test.vbs(10, 1)
ADODB.Connection: Provider cannot be found. It may not be properly
installed.
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.3;11.5;8.5;8.7;9.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
25 April 2025
UID
swg21986908