Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Syntax of the ADO connection String

323427Aug 14 2002
Hi,

I have been trying to connect to an Oracle database from a client application (Delphi) using the ADO (Microsoft
ActiveX Data Objects) libraries... I have been successful so far when it comes to connecting normal users, but so far
I havent been able to connect as SYS.

The problem here is that when connecting as SYS to an Oracle 9i database it requires that I log in as SYSDBA, now
my problem is that I dont know what the parameter should be in the connection string to do that.

Thanks in advance,

/Sasakthi

P.S. The connection string (which works ok) looks like this:
'Provider=OraOLEDB.Oracle;Data Source=TEST;User ID=SYS;Password=BlahBlah;PLSQLRSet=1;'

how do I fit in SYSDBA into the above string ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2002
Added on Aug 14 2002
0 comments
855 views