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