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

[upadhyay40]

Hi saket,

I got error "Item cannot be found in the collection corresponding to the requested name or ordinal" on line 4

My code is

Code:

Set ConObj = CreateObject("ADODB.Connection")
ConObj.Provider = "MSDAORA.1"
ConObj.Properties("Data Source").Value = "15.5.7.13"
ConObj.Properties("Initial Catalog").Value = "sid"
ConObj.Properties("User ID").Value = "User"
ConObj.Properties("Password").Value = "Pass"
ConObj.Open
If ConObj.Errors.Count = 0 Then
    Set RecObj = CreateObject("ADODB.Recordset")
    RecObj.Open "select * from USER", ConObj,adLockPessimistic
End if

Please let me know if i make any mistake, hoping for your cooperation

Thanks
Mahesh