ADO - blank datagrid, why?

[Kirimi]

ORACLE n VB

Private Sub Form_Load()
Dim db As Connection
Set db = New Connection
db.CursorLocation = adUseClient
'db.Open "PROVIDER=MSDASQL;driver={Oracle in DataBase};server=davie;uid=davie;pwd=pix;database=davie;"
db.Open "PROVIDER=MSDataShape;Data PROVIDER=MSDASQL;dsn=DAVIE;uid=davie;pwd=pix;database=registry;"
Set adoPrimaryRS = New Recordset
adoPrimaryRS.Open "select NO, NAME, CLASS, JOIN, LEAVE FROM DAVIE.STUD WHERE NO = '& *txtNo.text*'", db, adOpenStatic, adLockOptimistic
Dim oText As TextBox
'Bind the text boxes to the data provider
For Each oText In Me.txtFields
Set oText.DataSource = adoPrimaryRS
Next
End Sub

'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''Question
Q: this code brings a blank datagrid, why?

 

[fpineda101]

This question should be a new topic of discussion. A new posting...

I'll answer your question with two of mine.

Is there data in the table?
Why are you using classic ADO?

Using ADO.NET, you can test the datagrid during coding to see if it will work. That is, load the data correctly. I suggest you use ADO.NET. The techgnome highly recommends it!

 

[cjard]

is there a reason why youre using the datashape driver rather than a specific oracle driver (ole db for oracle or oracle client proper)