Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Don Child

Programmer
Apr 4, 2003
63
2
8
US
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


 
Just out of interest, try:

%windir%\syswow64\cscript.exe c:\ProjectFolder\CompareThisDB_to_ThatDB.wsf
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top