Can you successfully create Connection Object?
>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.
- Jayesh