Data Source is a device or original media that provides a certain required data. As the name suggests, the source of the data. Stored in the data source all the information to establish a database connection. Just as you can find a file in the file system by specifying the file name, you can find the corresponding database connection by providing the correct data source name. This sharing will teach you how to configure the data source on windows to make it easier for you to operate the database at work.
Tools/Materials
<p>The configuration environment is Windows</p>
Method/Step
Configure the mysql data source:
Click [Start] → select [Control Panel] → [Management Tools] → [Data Source]
Select [System DSN] → click the [Add] button → select [mysql 5.1 driver], the added data source will be displayed in the system DSN list, which can be modified and maintained.
Date Source Name is the name of the data source displayed in the added system DSN list
Select TCP/IP Server and fill in the IP and port port
user fill in the login database user name
password Fill in the login database password
datebase fill in the specified database name
After filling in the database information → click the [test] button in the lower right corner of the interface, if a prompt box pops up to indicate: "Connection successful", the configuration is successful.
After filling in the database information → click the [test] button in the lower right corner of the interface, as shown in the figure below. I'm sorry for the failure. At this time, carefully check whether the information filled in is correct. Of course, you can log in with other database software to try.
END
Precautions
Select the correct data source driver, as shown in the article, the mysql5.1 driver used corresponds to the mysql database.
The login information was filled in correctly when adding the data source.
Press the "test" button once before saving, the necessary tests will be done with half the effort.
Account not verified