Connect ODBC to access MySql

Source: Internet
Author: User
Environment: windows2008 + sqlserver2008 A installation mysql-connector-odbc-5.2.5-winx64.msi must be installed 5.2.5, install the mysql-connector-odbc-5.3.4-winx64 will report Error 2 configuration ODBC after installation in the control panel-management tools-data source (ODBC) -> System DNS-> Add. You must select ANSIDriver. Otherwise

Environment: windows 2008 + sqlserver 2008 one installation mysql-connector-odbc-5.2.5-winx64.msi must be installed 5.2.5, installation mysql-connector-odbc-5.3.4-winx64 will report Error 2 configuration ODBC after installation in Control Panel-administration tools-Data Source (ODBC) -> System DNS-> Add. You must select ANSIDriver. Otherwise

Environment: windows 2008 + sqlserver 2008

One install mysql-connector-odbc-5.2.5-winx64.msi

5.2.5 must be installed, and an error is reported when the mysql-connector-odbc-5.3.4-winx64 is installed

Ii. Configure ODBC

After installation, choose Control Panel> Administrative Tools> data source (ODBC)> System DNS>. You must select the ANSI Driver. Otherwise, Chinese characters are garbled.

Create a linked server in Sqlserver

4. Test the linked server performance

Select * from openquery (MYSQL213, 'select * from Mysql table ')

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.