MySQL Database Connection - Visual Basic , VB.NET

	Find Code:
Home : Code : Forums : Submit : Mailing List : About : Contact

All

VB.NET

ASP.NET

C#

Snippets

Popular

Forums

Articles

Tips

Links

Books

Contest

MySQL Database Connection
Author: Sean D
Submitted: 11/28/2012
Version: VB 2005
Compatibility: VB 2005, VB 2008, VB 2010, VB 2012
Category: Databases
Views: 12125
Connection string for connecting to MySQL database from vb.net.
Declarations:
'none
Code:
Imports MySql.Data.MySqlClient Public Class MySQLConnect Private db_con As New MySqlConnection Private Sub connect() Dim dbname As String = "DBNAME" Dim dbhost As String = "localhost" Dim user As String = "root" Dim pass As String = "DBPASSWORD" If Not db_con Is Nothing Then db_con.Close() db_con.ConnectionString = String.Format("server={0}; user id={1}; password={2}; database={3}; pooling=false", dbhost, user, pass, dbname) Try db_con.Open() Catch ex As MySqlException MsgBox("Database Error:[" & ex.Message & "]") End Try End Sub End Class