Find Code:
All Words
Any of the Words
Exact Phrase
Home
:
Code
:
Forums
:
Submit
:
Mailing List
:
About
:
Contact
Code
All
VB.NET
ASP.NET
C#
VB Classic
ASP Classic
Snippets
Popular
Resources
Submit Code
Forums
Articles
Tips
Links
Books
Contest
Link to us
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:
12130
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
Home
|
Forums
|
Submit
|
Books
|
Mailing List
|
Advertising
|
About
|
Contact
© 2024 A1VBCode. All rights reserved.
Legal disclaimer & terms of use
Privacy statement