Login DataBase "SYS as SYSDBA" not possible

Hi Chris,



Considering the amount of the information you've provided us with, the only guess I have is that checkpoint contains incorrect connection string to the database.

I used following command :

  Provider=MSDAORA.1;Password=xxxx;User ID="SYS as SYSDBA";Data Source=xxxxx;Persist Security Info=True;



It says that login is not correct.



If I use following command (not SYS), it works :

Provider=MSDAORA.1;Password=xxxx;User ID="xxxx";Data Source=xxxx;Persist Security Info=True;



So, what is the method to connect with : SYS as SYSDBA?

It works with sqlplus command.



What is the syntax?

Hi Chris,



According to https://www.connectionstrings.com/oracle/ it should be something like:

Data Source=myOracleDB;User Id=SYS;Password=SYS;DBA Privilege=SYSDBA;



Does it help?

Hi Chris,



Concatenate two or more variables.

E.g. (VBScript untested sample):



Dim strPassword

Dim strConnStr



strPassword = <get password from file>

...

strConnStr = aqString.Format("Data Source=myOracleDB;User Id=SYS;Password=%s;DBA Privilege=SYSDBA;", _

  strPassword)

...