Terry,
I might be off base here, but I thought that in order to use oledb (active dataobjects) you needed to also install a server part onto the mysql server. At least I thought I read something like that.
Bob Lee


>Sergey
>I tried to use ADO to build a recordset connected to a UNIX MySQL through a Win98 desktop ODBC. The connectionstring did not error and the recordsource (the SQL SELECT) did not error. I used methods similar to the ADO Query Analyzer in the DOWNLOAD area.
>
>I might add that PASSTHROUGH (SQLCONNECT and SQLEXE) worked as predicted,and returned a cursor, but ADO would not build a recordset and would not tell me why!
>
>ANy ideas?
>Terry
>
>>>can I use Microsoft SQL as back end and Visual foxpro without having to create table or database inside visual foxpro
>>>any help
>>
>>You can use SQL Pass-Through (SPT) or/and ADO to access Sql Server from VFP. Take a look at DataClas/VFP, for example.