Like I said, I might be off.
from the oledb file of mysql or myoledb
If you use ADO, set connection string to Provider=MySQLProv; Data Source=xxx, where xxx is

name of MySQL database - like test
or a connection string like one used in MyODBC - like server=localhost;DB=test



Bob Lee



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