Advanced Search

Adding Linked Server to MSSQL

/ Published in: SQL
Save to your folder(s)
Adding a linked server to MSSQL account - particularly a MYSQL server

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.