Posted By

kidmizere on 02/28/14


Tagged

mysql mssql server linked


Versions (?)

Adding Linked Server to MSSQL


 / Published in: SQL
 

Adding a linked server to MSSQL account - particularly a MYSQL server

  1. EXEC MASTER .dbo.sp_addlinkedserver
  2. @SERVER = 'MYSQL',
  3. @srvproduct = 'MySQL',
  4. @provider = 'MSDASQL',
  5. @provstr = 'DRIVER={MySQL ODBC 5.2 Ansi Driver};SERVER=ServerName;Port=3306;USER=USERNAME;PASSWORD=PASSWORD;OPTION=3;DATABASE=DATABASE';

Report this snippet  

You need to login to post a comment.