Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

Links

XODOX
Impressum

#1: MSSQL - MySQL

Posted on 2008-04-25 00:10:09 by Gosth in the shell

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

Report this message