Terry,

Not sure what you mean by

"Do you have an empty cursor with a field structure?"

and

"Are the field definitions translating?"


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.

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?