Hi I have to connect to the oracle database using sys user using a vbscript.
Does anybody know how to do it?

Also do i need to connect as sys dba to run the query using sys user? If yes then how can this be done in vbscript?

Thanks in advance.

Hi,

If you were using Oracle's ODBC driver, you'd add "as sysdba" as part of the password, ie:
"DRIVER={oracle in oradb11g_home1};dbq=XYZ;UID=sys;PWD=abc as sysdba;"

However, you're using Microsoft's driver and I wouldnt be surprised if Microsoft's driver doesnt support it. If it does though, I'm not sure what you need to do.... Thanks for sharing the post...