How to create a linked server is Microsoft SQL Server to a MYSQL database. 1. Download mysql odbc driver 2. Create odbc connection 3. Change MSDASQL provider in linked servers providers to have: * nested queries * level zero only * allow inprocess * supports like operator 4. Create linked server * catalog is your database name * Product name is "MySQL" * Data source: matches your odbc name 5. Query logic is "select * from linkedserver...table REMEBER: table names are case sensive |
SQL Server >