468,535 Members | 1,540 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,535 developers. It's quick & easy.

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 1583

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 this site, you agree to our Privacy Policy and Terms of Use.