I'm trying to connect to Oracle as the SYS user using ADO in an InstallScript function, but I keep getting an error saying I need to connect as sysdba.
I've followed the steps in this post but to no avail.
My connection string is Provider=OraOLEDB.Oracle;Data Source=MyDatabase;User ID=SYS;Password=password;
In the ISSQLDBMetaData table in Direct Editor, I've changed the following columns to these values: AdoDriverName: {Oracle in client11_home1} AdoCxnServer: DBQ= ISAttributes: 6 AdoCxnAdditional: DBA Privilege=SYSDBA
When I connect as SYSTEM, without as sysdba, things work fine. But when I try as SYS, it fails to connect. If I add AS SYSDBA to the password field in my connection string, I get an invalid password error.
Apparently, the problem was in the connection string. OLEDB does not support connecting as SYSDBA, so I changed "Provider=OraOLEDB.Oracle" to "Driver={Oracle in client11_home1}" and "Data Source" to "DBQ", and I could then connect as SYSDBA.
