Click here to Skip to main content
15,888,031 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL> desc admin
 Name              Null?    Type
 -------------------------------------
 NAME                      VARCHAR2(20)
 PRIVILEDGE                VARCHAR2(20)
 CODE                      NUMBER(38)
 PASS                      VARCHAR2(20)

VB
Private Sub Form_Load()
Set RS = New ADODB.Recordset
If RS.State = 1 Then RS.Close
opencn
RS.Open "ADMIN", CN, adOpenDynamic, adLockOptimistic, adCmdTable
Set DBGrid1.DataSource = RS
RS.Close
End Sub

Error 430 at line : Set DBGrid1.DataSource = RS
Class does not support automation or does not support expected interface


Please help.......
Posted
Updated 19-Feb-13 4:15am
v2
Comments
CHill60 19-Feb-13 8:59am    
Are you using component "Microsoft Data Bound Grid Control 5.0 (SP3)" or "Microsoft DataGrid Control 6.0 (SP6) (OLEDB)"
If the former then swap it for the latter - if you get a bookmarking error then set the connection cursorlocation to adUseClient

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900