Hello,

I'm currently using MyODBC 3.51.06 to link to a MySQL Database with MSSQL's Enterprise Manager and it's working fine except for one thing.

When I try to run a Stored Procedure on the MSSQL box hitting the MySQL Database (via a pass-through query) I get the following error message:

"Heterogenous queries require the ANSI_NULLS and ANSI_WARNINGS
options to be set for the connection".

Is there an option I set in the MyODBC driver that equates to ANSI_NULLS and ANSI_WARNINGS being turned on?

I'm quite desperate.

Thanks.

try this before calling the stored procedure:

SET ANSI_NULLS ON SET ANSI_WARNINGS ON

GO



You might also want to take a look at:

http://www.sqlmag.com/Forums/message...2&threadid=739

http://www.experts-exchange.com/Data..._20629811.html

http://www.informit.com/isapi/produc...t/articlex.asp