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!
-
ODBC from VBS
Last error resolved and now I can connect to Oracle db. Reason for last error was call to email function to send email with information when error occurs. I believe Email functionality for SMTP is either not setup right from my id or port is blocked, and not allowing me to send error email... -
ODBC from VBS
MS Access connection is working fine. Kind of passed through the previous Oracle connection error but got different Oracle connection error now. Since DSN was defined in ODBC as TEST_DSN, to resolve previous error, I referred to DSN instead of tnsname (like below). Content of Cofig.ini... -
ODBC from VBS
@strongm (MIS) "%windir%\syswow64\cscript.exe Test.vbs" Worked!!! Thank you very much. I can now be connected to Access db but Oracle connection via dsn still doesnt connect. Any idea ? I tried following since Oracle is 32 bit driver just to see but then Access did not work nor Oracle... -
ODBC from VBS
This is my first attempt at modifying existing VB Script (worked with korn shells before). Do I need MS Visual studio for debugging? I just copied the script and use script's log file for debugging. I am trying to modify VB script that accesses following databases on Windows 10 using ODBC: 1)...
