By default, the host name is localhost and IP address is 127.0.0.1. In the text box, type a host name or IP address of the MySQL server. In this example, the TCP/IP Server radio button is selected. Use the TCP/IP Server or Named Pipe connection method to connect to MySQL by selecting appropriate radio button. In the Description text box, enter the description of the data source if needed. In the MySQL Connector/ODBC Data Source Configuration dialog:įor the Data Source Name text box, enter the data source name by choice. #Sql server management studio 17 localhost driverIn the Create New Data Source dialog, select the MySQL ODBC Driver and press the Finish button: To connect to MySQL database using ODBC drivers, in the ODBC Data Source Administrator dialog, under the System DSN tab, press the Add button: #Sql server management studio 17 localhost driversUnder the Drivers tab of the ODBC Data Source Administrator dialog box, check if the MySQL ODBC Drivers exist: To confirm that ODBC driver for MySQL is installed on machine can be checked from Control Panel:Īnother way to check is via the ODBC Data Source Administrator dialog box: #Sql server management studio 17 localhost installPress the Install button to install ODBC driver:Īfter a couple of seconds, installation of ODBC driver for MySQL is finished : The Ready to Install the Program dialog shows what and where will be installed. Under the Setup Type dialog, choose the Typical radio button and press the Next button: If you agree with the license agreement, press the I accept the terms in the license agreement radio button and click the Next button: Double-click on the downloaded file, the Welcome dialog will appear:Īfter pressing the Next button, the License Agreement dialog appears. Installation of MySQL ODBC driver for Windows is straightforward. Mysql-connector-odbc-8.0.17-win圆4.msi for 64-bit application Mysql-connector-odbc-8.0.17-win32.msi for 32-bit application There are two versions of MySQL ODBC drivers for Windows that can be installed, depending on which application will be used with: Under this link, the MySQL ODBC drivers for Windows can be downloaded and installed. Generally, that is API (Application Programming Interface) for accessing database systems.įor non-Windows OS, JDBC (Java Database Connectivity) is used.īefore installing the ODBC driver for MySQL on Windows, make sure that Microsoft Data Access Components (MDAC) are up to date and the Microsoft Visual C++ 2013 Redistributable Package is installed on your system. It’s developed by Microsoft in the 1990s. ODBC stands for Open Database Connectivity (Connector). This article is divided in three sections:Ĭonfigure ODBC driver to connect to MySQL databaseĬreate and configure a Linked Server using ODBC driver This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |