flexgrid won't recognize ado on form

[gremmy]

I'm using an ado to connect to a flexgrid but the when I click the DataSource property on the flexgrid it says "No compatible data source found". ANy ideas?

Thanks

[vbuser1976]

From what I understand, if you are using an ADO connection, have you opened a recordset? If you want to do it that way, you would have to set the datasource equal to the recordset after you have opened it. Here's an example:

rs.Open sSQLSelect, gobjConnect, adOpenStatic, adLockBatchOptimistic, adCmdText 
If Not rs.EOF And Not rs.BOF Then 
rs.MoveFirst 
End If 

rs.ActiveConnection = Nothing 

Set FlexGrid1.DataSource = rs

sSQLSelect could be a string SQL command, table, or stored procedure. gobjConnect is the name of the connection.

You can read more about this here:
R U a Datagrid(ADO) Pro?
Going Crazy!!!

I hope this helps and Good Luck!