Click OK to save the ODBC connection properties and close the dialog Select the desiredĭatabase name from Databases drop-down box. If you are using Named Pipe protocol, then select Named Pipe and enter the appropriate valueĮnter the username and password in the User and Password text box to authenticate to the server. If you are using TCP/IP protocol to connect to MySQL, then click on TCP/IP Server and provide the name and the port Provide the desired name and the description of the Data source. In the Data Source name and description text box, MySQL ODBC 8.0 ANSI Driver or MySQL ODBC 8.0 Unicode Driver andĪ dialog box MySQL Connector/ODBC Data Source configuration opens. We want to set up MySQL ODBC Data source, hence choose ODBC drivers that are installed on the computer. In the list, you can see all see the list of various We want to create a new System DSN hence click on SystemĪ dialog box Create New Data Source opens. Panel Open Administrative Tools Open ODBC Data source (64-bit) See the following image:Ī dialog box ODBC Data Source Administrator dialog box opens. (64-bit) is used to install and manage the ODBC drivers of various databases. Once the driver is installed, let us configure the ODBC data source for MySQL. You can choose the different version of MySQL from the Select Products and Features screen. When we install the MySQL server, the ODBC driver for MySQL is installed automatically. Every database platform provides its setup of ODBCĭrivers that can be used to connect Windows or Linux applications to connect to the database. Or other database servers like MySQL, Oracle, or PostgreSQL. First, let me talk about ODBC drivers.Ĭonnectivity, is provided by Microsoft that allows us to connect the application to the SQL Server MySQL and use it to create an SSRS report. We will go through the process to set up the ODBC driver for In this article, I am going to explain ODBC drivers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |