Adding Linked Server to MSSQL

Submitted by:Pitter Alderson

Date added:07 April, 2014

Category:SQL

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

Tags: linked server

Code Snippet:

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

Comments