![]() You should now see the data source name you supplied on the form in the previous set listed on the ODBC Data Source Administrator window: In the future, you can grant additional privileges if necessary.Īfter you have supplied the details for your data source configuration, you should click on the Test button to make sure everything is in working order. For “production” environments, it is suggested you create a new user and grant the new user SELECT privileges only. The MySQL database and table we’re using for this post is on a development machine and is only used by one person. Next you will need to supply the information necessary to complete the form shown above. You should now see a window similar to the one listed below: ![]() ![]() To continue creating the DSN, make sure MySQL ODBC 5.x Driver is highlighted and click on the Finish button. ![]() If it’s not present, something went wrong with installing the driver in the Preparation section of this post. You will probably have to scroll down to see the MySQL ODBC 5.x Driver. To continue creating the DSN, click on the Add button near the top right corner. DSN file that can be transported to and used on other systems that have the same OS and drivers installed. A System DSN is available to anyone that can log into the machine. A User DSN is only available to the user that created it.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |