toooki
asked on
Connect to MySQL via C# .NET (Visual studion 2008)
Which client library can we use to connect to a MySQL 5.0 database from MS .NET Visual Studio 2008 code?
I use
using System.Data.OracleClient;;
using System.Data.SqlClient;
for Oracle and SQL server databases respectively.
I use
using System.Data.OracleClient;;
using System.Data.SqlClient;
for Oracle and SQL server databases respectively.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can try OleDbConnection class:
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection(v=vs.80).aspx
This way will allow you to connect to any of the most common databases by just changing the connection string.
The following website can help you to determine the appropriate connection string:
http://www.connectionstrings.com
http://msdn.microsoft.com/en-us/library/system.data.oledb.oledbconnection(v=vs.80).aspx
This way will allow you to connect to any of the most common databases by just changing the connection string.
The following website can help you to determine the appropriate connection string:
http://www.connectionstrings.com
ASKER
Thank you. I am going to check this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks srosebabu. I am going to try this soon.
ASKER
I am going to check the details you sent to me.