Join us for SoftSummit 2023. The 20th anniversary of the industry leading software monetization conference. April 18 and 20. Register Now

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 8

Connect to Oracle as SYSDBA using ADO

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.

I'm not sure what I'm doing wrong. Help please.
Labels (1)
0 Kudos
1 Reply
Level 8

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.
0 Kudos