I tried installing "instantclient-basic-windows.x64-18.104.22.168.0" and "instantclient-odbc-windows.x64-22.214.171.124.0" both. I ran the odbc_install.exe in command prompt as administrator and got the message "Oracle ODBC Driver is installed successfully."
I also set the environment Variable "Path" as "C:\instantclient_11_2".
But when tried to use the above VBScript to connect to the Oracle DB, i get the same error message. I am really stuck with this for past two days.
The above issue has been resolved. Since QTP is a 32 bit Application, we might need to use the 32 bit ODBC Data Source Administrator for creating the Oracle DNS. By default the control panel shows the 64 bit ODBC Data Source Administrator. Hence we need to use the “C:\Windows\SysWOW64\odbcad32.exe” from the Start-Run menu and open the 32 bit ODBC connection to create a Oracle DSN and then use that in the VBScript