Retriving the data from oracle database
I have tried with a script for getting the value from oracle database. but it throws an error. Can any one help on it. I have selcted Micorsoft Activex object 2.7 library in reference. It throws an error as [Microsoft odbc Driver Manager]Driver's SQLSetConnectAttrfailed
Dim dbcon As New ADODB.Connection
Dim rs As New ADODB.Recordset
dbcon.CursorLocation = adUseClient
dbcon.Open "DSN=ClearCourse_krishna1;UID ='gva_s02';PWD='s02_gva';DATABASE=t1gva.world"
ssql = "select * from grp_mstr"
rs.Open ssql, dbcon, 3, 2
While rs.EOF = False