Virtual Brain Online Logo

Bookmark: Root \ Visual Basic.NET \ Mysql.data.dll installation instructions for VB.NET

Mysql.data.dll installation instructions for VB.NET


Last Updated: 2005-11-24

pairash plearnmalai wrote:
> 1. Add Reference
> 2. Browse
> 3. Select File 'MySql.Data.dll'
> at
> C:\Program Files\MySQL\MySQL Connector Net
> 1.0.3\bin.\NET 1.1
> 4. You put code
> Imports MySql.Data.MySqlClient

And the connection string may look something like this (it has worked in my .NET code):

conn.ConnectionString = "User ID=" + _authInfo.UserName + ";" +
"Password=" + _authInfo.UserPassword + ";" +
"Host=localhost;" +
"Port=3306;";

This connection does not use a database, but you can extend the connection string with "database=xxx;"

A piece of me wishes that Connection objects had a consistent connection string semantic. It is annoying that and OdbcConnection requires UID whereas an ADO.NET connection requires "User ID", and other such differences. It would also be nice if the .NET connector providers would document the connection string arguments like they did for the ODBC connector.

I have been using the OdbcConnector, but in the case where I want my tool to create a database, I needed to use a direct connection. Depending on how well this connector works (compared to the more tried and true ODBC connector) I may start switching over other code.

 

Title: Download
Posted By: Aron On: 2012-10-26 13:31
Running: Mozilla/5.0 (Windows NT 5.1; rv:15.0) Gecko/20100101 Firefox/15.0.1
Where is the download link for Mysql.Data.dll
I need it so hard....

EDIT By Admin:
http://dev.mysql.com/downloads/connector/net/

 

Add Your Comment:

Note: All posts require administrator approval. Please allow 24 hours for message approval.

Name:
E-Mail:
Title
Plain text only, less then 65 000 characters.

Please answer the question above and type the answer into the text box below.