gipasoft

Add MySql linked server

Nov 7th, 2012
291
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.22 KB | None | 0 0
  1. EXEC master.dbo.sp_addlinkedserver
  2. @server = N'MYSQL',
  3. @srvproduct=N'MySql',
  4. @provider=N'MSDASQL',
  5. @provstr=N'DRIVER={MySQL ODBC 5.1 Driver}; SERVER=10.0.0.88; DATABASE=mysqldb; USER=root; PASSWORD=rootpassword; OPTION=3'
Advertisement
Add Comment
Please, Sign In to add comment