Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unhappy Unanswered: Please help with MyODBC

    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.

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •