delphi - How can I connect to an Oracle database as SYSDBA using dbExpress? -


I have a Delphi application that connects to a database.

When I try to log in to SYSDBA, I get an error:

  ORA-28009: SYS as connection to SYSDBA or SYSOPER  

When I try to log in with a user "SYS AS SYSDBA", I get an error:

  ORA-01017: Invalid username / password; Logon denied  

How can I log in as sysdba using a Dbe Express connection?

I did not find anything for special dbexpress driver . But try adding a DBA privilege connection parameter with SYSDBA .

  connection.param .Append ('DBA privilege = SYSDBA');  

I have no Delphi installed to check the solid syntax of the parameter name. Please try to use underscores instead of the empty space.

Oracle shows several connection strings used in some devices to connect to the database.


Comments

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

html - CSS autoheight, but fit content to height of div -

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -