Are you suggesting it may be necessary to place a COM on the MySQL server? The server is UNIX! Tell me what you meant by "install a server part onto the mysql server". It may be an answer!


>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.