Hi, I'm having trouble binding a recordset to the Microsoft FlexGrid Control version 6.0, basically I can't :). I know it's supposed to be a straight forward process, and I've been reading through previous posts about it and it seems there hasn't been an answer for those who have had the same problem. This is the code:

public goConn, goRS

goConn = Createobject("adodb.connection")
goRS = CreateObject("adodb.recordset")
goConn.ConnectionString = "data source = northwind;user id = sa"
goConn.Open

goRS.ActiveConnection = goConn

goRS.Open("employee")

wait wind goRS.Fields(1).Value && Just for checking

ThisForm.Flexgrid1.DataSource = goRS && Type Mismatch

ThisForm.Flexgrid1.DataSource = goRS.Object && Unknown Name 

As indicated in the code I get either type mismatch or unknown name.

I'm using VFP 6 SP4 on a Windows 2000 machine

TIA