runtime error err number is -2147467259

[arifvbhelp]

Hai
I am arif.I am a vb programmer.I try to open the recordset but one error coming that is methot 'open' of 'object_recordset' failed.


Private sub cmdcheck_click()
dim rscom as adodb.recordset
s1="select * from class_subj where class='"& trim(lstclass) & "' and section=
'"& trim(lstsection) & "'"
set rscom=new adodb.recordset
rscom.cursorlocation=aduseclient
rscom.open s1,con,adopendynamic,adlockoptimistic
rscom.close
set rscom= Nothing
End sub

Please clear this problem

regards
ARIF

 

[arifvbhelp]

vb recordset opening error

Hai
I am arif.I am a vb programmer.I try to open the recordset but one error coming that is methot 'open' of 'object_recordset' failed.


Private sub cmdcheck_click()
dim rscom as adodb.recordset
s1="select * from class_subj where class='"& trim(lstclass) & "' and section=
'"& trim(lstsection) & "'"
set rscom=new adodb.recordset
rscom.cursorlocation=aduseclient
rscom.open s1,con,adopendynamic,adlockoptimistic
rscom.close
set rscom= Nothing
End sub

Please clear this problem

regards
ARIF

 

[arifvbhelp]

Hai
I am arif.I am a vb programmer.I try to open the recordset but one error coming that is methot 'open' of 'object_recordset' failed.


Private sub cmdcheck_click()
dim rscom as adodb.recordset
s1="select * from class_subj where class='"& trim(lstclass) & "' and section=
'"& trim(lstsection) & "'"
set rscom=new adodb.recordset
rscom.cursorlocation=aduseclient
rscom.open s1,con,adopendynamic,adlockoptimistic
rscom.close
set rscom= Nothing
End sub

Please clear this problem

regards
ARIF