In downloads their is a program (ADO Query Analyser). Just two entries: A connection string, and a recordstring (select). Download it and see if it populates the view. If it does - then ADO is returning records.

To see if Ado has returned data:?oRecSet.Reccount


>Not sure what you mean by
>"Do you have an empty cursor with a field structure?"
I thought you were implementing CursorAdaptor to translate a oRs to a VFP cursor. BROWSEing the cursor would show structure and data
>
>and
>
>"Are the field definitions translating?"
Is the ADO precision translating to the Adapted cursor?
>
>
>As for your question "Are there records in the recordset?", not
>that I can see. Thats why I'm not sure whats supposed to happen.
>The ADO sections in the code example I posted appear to be correct,
>so I'm not sure whats going on.
Check out ADO Query Analyser and read this article by one of our alumni:
http://www.msdn.microsoft.com/library/default.asp?URL=/library/techart/ADOJump.htm

Let me know how it works out!


>Here is a segment of code using the the same Provider and conn string
>This works:
>
>

>oConn 	= CREATEOBJECT("ADODB.Connection")
>oRecSet	= CREATEOBJECT("ADODB.Recordset")
>
>oConn.ConnectionString = ;
>	"Provider=VFPOLEDB.1;Data Source=" +;
>	"d:\projects\visual foxpro\bm\data\;" +;
>	"Mode=ReadWrite|Share Deny None;"
>
>oConn.Open()
>
>oRecSet.ActiveConnection = oConn
>
>oRecSet.Open("select * from clients")
>

>
>
>So, what's wrong with the previous code I posted?