Post reply

executing a mysql stored procedure from sql server 2005?

  • December 10, 2008 at 1:10 pm

    #125744

    Hello,

    Anyone know if the above can be done? Pretty sure the answer is "no", but thought I'd ask the group.

    I have successfully setup a linked server from SQL Server 2005 to mysql v5 and can easily execute cross-server joins using 4-part convention, but the performance is slow as it doesn't appear to be using the native mysql indexes on large tables.

    What I'd like to be able to do is execute a mysql stored proc from sql server, such as:

    execute mysqlsrv...sp_getorders '12/10/2008'

    Seems like this should (eventually) be possible.

    Thanks,

    Joe

  • February 11, 2009 at 3:12 pm

    #942521

    Hi Joe,

    I wonder did you ever get this working? I am trying to do the exact same thing and it isn't working.

    Hope you can help.

    Many Thanks in Advance

    Stephen

  • February 12, 2009 at 6:57 pm

    #943321

    We use OPENQUERY() with a linked server on an older version of MySQL. I'm not sure if it will run a remote stored proc, but you might want to give it a try.

    Dave

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply