treffynnon/mysql-link.sql

Created February 4, 2010 15:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/treffynnon/294726.js"></script>
Save treffynnon/294726 to your computer and use it in GitHub Desktop.

Download ZIP

Setup the MySQL ODBC connection

Raw

mysql-link.sql

EXEC master.dbo.sp_addlinkedserver @server = N'MYSQL', @srvproduct=N'MySQL', @provider=N'MSDASQL', @provstr=N'DRIVER={MySQL ODBC 3.51 Driver}; SERVER=MySQLServerIP; DATABASE=Db_NAME; USER=MySQLUserName; PASSWORD=MySQLPassword; OPTION=3'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment