>Have you tried this without the vfp ole db provider present?

Can't say as I have until now. Easy enough to replicate...

> I have the vfp odbc driver installed from mdac 2.5. After installing mdac 2.6, the vfp driver was still be available, but none of the VFP/ADO code (using MSDASQL) worked any more.

Just as a quick sanity check, I ran the following in VFP 7, with the VFP provider disabled:

Local oCat As "adox.catalog"
LOCAL oConn As "Adodb.Connection"
LOCAL oCmd As "Adodb.Command"
LOCAL oRs As "Adodb.Recordset"

oConn = CREATEOBJECT("adodb.Connection")
oCat = CREATEOBJECT("adox.catalog")
oCmd = CREATEOBJECT("Adodb.Command")

oConn.ConnectionString = "dsn=vfptest"
oConn.CursorLocation = 3  && adUseClient 
oConn.Open
oCat.ActiveConnection = oConn

Works like a champ. Can you be more specific about what's breaking?