by 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
(http://support.microsoft.com/default.aspx?scid=kb;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
suppose).
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)
www.economia.unipd.it
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,