Galene Posted May 7, 2015 Share Posted May 7, 2015 (edited) 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 Edited May 7, 2015 by Galene Link to comment Share on other sites More sharing options...
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
Already have an account? Sign in here.Sign In Now