Odbc driver name mysql

This will help you to identify the right DSN to use with applications such as Excel that are only compatible with the bit driver. In the Description box, enter some text to help identify the connection. By default, it is localhost. In the User field, enter the user name to use for this connection. In the Password field, enter the corresponding password for this connection. The Database pop-up should be automatically populated with the list of databases that the user has permissions to access.

To verify the connection using the parameters you have entered, click the Test button. If the connection can be made successfully, you will be notified with a Connection Successful dialog; otherwise, you will be notified with a Connection Failed dialog. You can configure a number of options for a specific DSN by clicking the Details button. Toggling the Details button opens or closes an additional tabbed display where you set additional options that include the following:.

Step 1 — Double-click on the file that is downloaded in MSI format. The output that can be seen after double-clicking is as follows — Click on run. Click on next. Step 4 — You can choose any of the option as per your need — typical, custom or complete. Select Typical option and click on next. Step 5 — There you go.

Program is ready for installation. Click on the install button. After completing the installation, we will need to configure the ODBC driver and its related connections. This will lead to pop up of the following window.

After clicking on the finish button, you will need to specify the fields that will be needed for configuring the DSN connection using the window of connection parameters as shown below. Now, click on the test button after entering the above details to check whether the database connection is getting pinged properly as shown below.

Make sure you use the 32 bit or the 64 bit version depending on your applications build target. Then select the "File DSN" tab. Add the rest of the parameters required, and you will have a working ODBC connection string for the currently installed version of the driver.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. How to find the ODBC driver name for a connection string? Ask Question. Asked 6 years, 2 months ago. Active 7 months ago. Viewed 22k times. Whenever I use ODBC drivers with a full connection string, and not just a DSN entry, I often get an error similar to this Data source name not found and no default driver specified I have the correct syntax of the connection string or so the Internet says , but I suspect I don't know the correct name for the current version of the ODBC driver I am using How do I find the correct name, for either 32 or 64 bit?