* ODBC test program

C:\temp>type odbctest.vbs
Dim ad
Dim sql_query
sql_query = "SELECT * FROM dual"

set ad = CreateObject("ADODB.Connection")
'ad.Open "Driver={Oracle in OraDB12Home1};DBQ=mydb;UID=testuser;password=testpassword" 'DSN-less config
ad.Open "DSN=mydsn;UID=testuser;password=testpassword" 'create mydsn first

Set rs = ad.execute(sql_query)
WScript.Echo rs("dummy")

ad.close
C:\temp>cscript odbctest.vbs
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

X


* OS tracing:

Run Process Monitor (procmon)
Filter on Process contains cscript
Capture
Run cscript odbctest.vbs
Stop Capture
Save file to Logfile.CSV in CSV format
C:\temp> findstr mydsn Logfile.CSV
"n/a","4:05:38.8174737 PM","cscript.exe","4316","RegOpenKey","HKCU\SOFTWARE\ODBC\ODBC.INI\mydsn","NAME NOT FOUND","Desired Access: Read"
"n/a","4:05:38.8174987 PM","cscript.exe","4316","RegOpenKey","HKLM\SOFTWARE\ODBC\ODBC.INI\mydsn","SUCCESS","Desired Access: Read"
...


* ODBC API tracing:

odbcad32 -> Tracing -> Start Tracing Now


* 32-bit ODBC on 64-bit Windows

c:\windows\syswow64\odbcad32 instead of default c:\windows\system32\odbcad32