another OLEDB driver for MySQL

[Chris Hylton]

http://www.colibri-soft.com/pr_myoledb.php

You might give the above OLEDB provider a try, it specifically indicates
it supports Linked Servers, so maybe they knew about the problem (assuming
there is one) you are having and developed an alternative OLEDB provider
for MySQL.

Chris

[Andy H]

Problem solved with the following options set:

OLE Provider for MySql Options:
Dynamic Parameters - False
Nested Queries - False
Level zero only - False
Allow InProcess - True
Non Transacted updates - False
Index as Access Path - False
Disallow adhoc access - False

Linked Server Options:
Collation Compatible = False
Data Access = True
RPC = False
RPC Out = False
Use Remote Collation = False
Collation Name = <empty>
Connection Timeout = 0
Query Timeout = 0


The problem may also have been related to the DTC not running on our server.

Thanks for your Help.
Andy


"Chris Hylton" <cchylton@hotmail.com> wrote:
>
>http://www.colibri-soft.com/pr_myoledb.php
>
>You might give the above OLEDB provider a try, it specifically indicates
>it supports Linked Servers, so maybe they knew about the problem (assuming
>there is one) you are having and developed an alternative OLEDB provider
>for MySQL.
>
>Chris