Select from MySQL via linked server

  • Hi,

    I've been using OPENQUERY to select from a MySQL db via a linked server

    and trying to use the four part method as below

    select  * from [MYSQL_LinkedSvr].[MySQLDb..MySQLTable

    As far as I can see there aren't any schemas on the MySQL server.

    Am I missing something?

    Any help most welcome.

    Thanks,

    Eamon

     

     

     

  • What error are you getting?

    The above is all just my opinion on what you should do. 
    As with all advice you find on a random internet forum - you shouldn't blindly follow it.  Always test on a test server to see if there is negative side effects before making changes to live!

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

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