Home Forums SQL Server 2005 Administering How to Create Linked Server for a MySQL database using SQL Server Management Studio RE: How to Create Linked Server for a MySQL database using SQL Server Management Studio

  • The above article has been very helpful and has helped me to successfully implement a linked server.

    However, has anyone gotten the 4-part naming convention to work with mysql? instead of using OpenQuery() ?

    eg. Select * from mysqlsrv.mysqldb.owner.table

    if so, can you add some explanatory comments to this post?

    Thanks,

    Joe