Jump to content

VBScript Connection oracle in sys


Recommended Posts


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 ?





Edited by Galene
Link to comment
Share on other sites

VBScript doesn't have very good error handling, it looks like the best you can do is tell it to continue on fatal errors, but then you need to check yourself to see if an error happened. That might be your only option. I doubt you will be able to tell the status of the database without connecting to the server, and if you get an error on connection then you'll need to handle that yourself.http://stackoverflow.com/questions/157747/vbscript-using-error-handling

Link to comment
Share on other sites

  • 2 weeks later...

it's work! with this method

Set cmd = sh.Exec("cmd /c "& ORACLE_HOME & "BINsqlplus.exe -s /@"&SERVICE &" as sysdba @Z:PartageSondeessaitest_recordsetrequetesql.sql")

it's a file where we go to execute queries

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...