471,084 Members | 801 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,084 software developers and data experts.

MSSQL - MySQL

Hi there, i need some help

I got a software to backend is MSSQL 2005, but a provider software
requires an UPDATE on his table with MySQL 5.0.56a backend, so i made
the next:

download and install ODBC MySQL 3.51
configuring system DSN
add a linked server on MSSQL 2005

then i made a stored procedure with a distributed transaction (UPDATE
OPENQUERY)but the query don't respect ANSI_NULLS and ANSI_WARNINGS
(ON), i don't know why send the follow message if i turn on ansi's:

"The heterogean queries require to stablish the options ANSI_NULLS and
ANSI_WARNINGS of the conection.
This ensures a consistent semantic query. Activate these options and
run again consultation."

then i take another way, to make a stored procedure on MySQL and call
it with my first stored procedure on MSSQL, EXEC ('CALL spTest') AT
"linked_server"
this message is send back:

The provider OLE DB "MSDASQL" for the linked server "localhost" send
back the message "[MySQL][ODBC 3.51 Driver]Optional feature not
supported".

the most weird thing is.. if i made the queries (OPENQUERY and EXEC)
in a new tab of MSSQL commands completed correctly.

I dunno if i new to configure anything else, i hope you can help me
dudes, so greetings
Jun 27 '08 #1
0 1648

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Alper Adatoz | last post: by
1 post views Thread by Gordan | last post: by
7 posts views Thread by mj | last post: by
16 posts views Thread by davemateer | last post: by
reply views Thread by exclaim | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.