How to Embed MySQL in Visual C

MySQL is used to allow for multiple users to access a database.

MySQL is a server system that provides access to one or more databases for multiple users. It is common for open-source projects that come with integrated database manipulation features to use MySQL. In addition to this, Microsoft recently made it possible to integrate the system into Visual Studio. Users can now use MySQL queries to operate with databases directly from ASP.NET applications, including ones designed in Visual C and Visual Basic.

Instructions

1. Download and install MySQL Connector from the MySQL download page. It is a free, officially supported add-on to allow MySQL integration into Visual Studio.

2. Launch the "ODBC Administrator" from the package installed in the previous step and select the "MySQL ODBC 3.51 Driver" from the window that pops up. Click "Finish" to continue.

3. Enter the information used to connect to the MySQL database. Fields such as the address of the server and the combination of username and password are mandatory. Press "OK" to complete the setup.

4. Launch Visual Studio and select the "Server" tab from the left side of the screen.

5. Locate the entry labeled "Data Connections." Right-click on it and select "Add Connection."

6. Click "Change" and select "Microsoft ODBC Data Source."

7. Click "OK" and MySQL will be integrated into Visual Studio, allowing the use of queries.

References

• Adefhelpdesk.com: MySQL Using Visual Studio 2005
• Webreference.com: Using MySQL With Your ASP.NET Applications

Resources

• MySQL: Download Connector/ODBC