How to write a script or database connectivity to connect oracle databse

[Saket]

hi upadhyay40,

use this piece of code to connect to your oracle database, and execute the query

Code:

Set ConObj = CreateObject("ADODB.Connection")
ConObj.Provider = "MSDAORA.1"
ConObj.Properties("Data Source").Value = YourServerName
ConObj.Properties("Initial Catalog").Value = YourDatabase
ConObj.Properties("User ID").Value = YourUserName
ConObj.Properties("Password").Value = YourPassword
ConObj.Open
If ConObj.Errors.Count = 0 Then
    Set RecObj = CreateObject("ADODB.Recordset")
    RecObj.Open YourQuery, ConObj,adLockPessimistic
End if

your results for the query will be in recordset RecObj
let me know if there is any issue.