Jump to content

Galene

Members
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Galene

  • Rank
    Newbie

Profile Information

  1. VBScript Connection oracle in sys

    it's work! with this method Set cmd = sh.Exec("cmd /c "& ORACLE_HOME & "BINsqlplus.exe -s /@"&SERVICE &" as sysdba @Z:PartageSondeessaitest_recordsetrequetesql.sql") @Z:PartageSondeessaitest_recordsetrequetesql.sql it's a file where we go to execute queries
  2. VBScript Connection oracle in sys

    I have watched this site and tried different connectionstringBut unable to connect with sysdba privilege
  3. VBScript Connection oracle in sys

    yes we can check the state before connecting, I have a probe that allows Linux to do, you just connect with the privilege " as sysdba" and I have to do the same but in vbscript.
  4. VBScript Connection oracle in sys

    two weeks of research and no solution I need help please
  5. VBScript Connection oracle in sys

    in fact I created a nagios probe for check the status of my databse that's why I need to connect in sysdba with my script but nothing works...
  6. VBScript Connection oracle in sys

    When my database is mount and I run my script I have a connection error err.number 3704, because you can log in sysdba when in state mount.
  7. hello I need to connect in sysdba on Oracle from Vbs. For retrieve the state of the database (Open mount ...) because the user system can not connect when the database is on mount. I use this command to connect on my database when she is open Set env = WshShell.Environment("PROCESS" ) computername = env("COMPUTERNAME" ) set cn = CreateObject("ADODB.Connection")set rs = CreateObject("ADODB.Recordset") ConnectionString ="Provider=OraOLEDB.Oracle; Data Source=" & _"(DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST="&computername&")(PORT=1521)))(CONNECT_DATA=(SID="&SERVICE &")(SERVER=DEDICATED)));" & _"User Id=system;Password="&PASSWORD &";"cn.Open connectionString can you help me please ? thanks Galene
×