MyODBC 3.51.01, OleDB, MS SQL Server And Linked Servers

MyODBC 3.51.01, OleDB, MS SQL Server And Linked Servers

Post by Pierfrancesco Consol » Sat, 02 Feb 2002 23:35:22

Dear MyODBC list,

        I'm not a DAO, ADO or "whatelse" programmer, but I have been waiting for
the new release of MyODBC, hoping that this could be used within a
'facility' included in MS SQL Server.

        I'm trying to connect a Unix MySQL Server to a NT MSSQL Server defining the
first as "Linked Server"  via "OLE DB for ODBC Driver" (using stored
procedure commands, or management console). I can access the tables for
reading using the OPENQUERY/OPENROWSET syntax, but I have found no success
in updating.
        The MS workarounds suggested in article Q270/1/19
(;EN-US;q270119) did not
resolve the problem.
        Neither with the new MyODBC 3.51.01 version. There is no support for the
linked_server_name.catalog.schema.object_name sintax (MySQL Server problem I

And also, for example, the error for the query

select * from openquery (mysql_linkedserver, "SELECT xfield FROM xtable;
UPDATE xtable SET xfield = '+++' WHERE xfield = '---' ")

is always something like

OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [MySQL][ODBC 3.51
Driver][mysqld-3.23.6-alpha-log]You have an error in your SQL syntax near ';
UPDATE xtable SET xfield = '+++' WHERE xfield = '---' ' at line 1]

I have tried the MyOleDB way too, but without success (perhaps without too
much understanding).

        Does someone succeded in this type of connections ?
        Perhaps the problem reside only in the MySQL server ? I have to upgrade the
MySQL server to 4.0 ? Or I have no choice ???

        Thanks in advance.

Consolo Pierfrancesco
Faculty of Economics - University of Padua (ITALY)

Please check "" before

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,