Oracle connection works while debugging in VBSEdit, but not when run from the command line. 1

[Don Child]

Hi,

I have an oracle connection defined


"Driver={Oracle in instantclient_21_6};Dbq=DB;Uid=MYUSERID;Pwd=" & ORACLE_S & ";"


, and this works fine while debugging in VBSEdit, with CSCript.


But the command line

c:\windows\system32\CMD.EXE /C CScript.exe c:\ProjectFolder\CompareThisDB_to_ThatDB.wsf

(We're using 32-bit drivers, and using 32-bit VBSEdit, therefore we're running the script from 32-bit cmd. But we also tried it with a 64-bit command line)

reports the standard odbc error

Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data Source name not found and no default driver specified

 

[strongm]

Just out of interest, try:

%windir%\syswow64\cscript.exe c:\ProjectFolder\CompareThisDB_to_ThatDB.wsf

 

[Don Child]

Thanks strongm, that did the trick.