The connection you just created should now be visible in the "System DSN" tab. If you did need to though, an alternate port number can be specified on the "Connect Options" tab.Ĭlick the "OK" button to finish setting up the connection - this will return you to the ODBC Data Source Administrator window. The MySQL driver uses a default port of 3306, so you should not need to enter a port number. (You will not be able to select a database unless you have entered the correct connection info in the above fields.) In the "Database" dropdown box, select the MySQL database you wish to use. Server - Enter just your domain name (for example, ****).Īfter you have entered the above fields, you can click on the "Test" button to see if the information you've entered is correct and you can make a connection to the MySQL server. On the "Login" tab are all of the fields you need to connect to the MySQL server.ĭata Source Name - This is the name that Excel will display as a data source.ĭescription - Text description of database connection. You should now see the "Connector/ODBC - Add Data Source Name" window. Scroll through the list of drivers displayed, select "MySQL ODBC 3.51 Driver", then click the "Finish" button.
In your Windows Control Panel, go into "Administrative Tools", then "Data Sources (ODBC)".Ĭlick on the "System DSN" tab. Once you've installed the MyODBC driver, then you need to set up a connection for the driver. (Scroll down to "Windows downloads" - I'd recommend downloading and installing the MSI installer.) If you have not installed it, you can download the MyODBC 3.51 driver from their Downloads page.
You did not indicate whether you've installed the MySQL Connector/ODBC (MyODBC) driver - it is required for what you want to do. I want to connect through MySQL odbc to a mysql database of mine on the TCH server. I want to make een Db query from within excel on my client at home.
0 kommentar(er)
