Mysql Database connection vb.net

Question

I'm trying to connect to a database but it doesn't work...

Code:

        Dim conn As MysqlConnection

    conn = New Mysqlconnection()
    conn.ConnectionString = "server=http://www.*****.net/phpMyAdmin; user id=*****; password=****; database=login"

    Try
        conn.Open()
    Catch myerror As MySqlException
        MsgBox("Error connecting to database!")
    End Try

it alsways says Error connecting to database!

what's the problem??

Try conn.Open() Catch myerror As MySqlException MsgBox(myerror.message) End Try This will give you more detailed exception information. — Jack
– Jack, Commented Apr 25, 2011 at 13:27

Adnan · Accepted Answer · 2011-04-25 10:42:50Z

3

You cannot use http://www.*****.net/phpMyAdmin for your server name. it should be just your domain name(hostname) mydomain.com or IP address 192.168.0.10

it should look as follow:

Dim conn As MySqlConnection = New MySqlConnection
conn.ConnectionString = "Host=192.168.0.10;user=root;password=root"
conn.Open()

answered Apr 25, 2011 at 10:42

Adnan

26.4k18 gold badges83 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ruben Over a year ago

Even if i do this 'conn.ConnectionString = "Host=***.*.**.***; user id=*******; password=******"' it doesn't work..

tiltdown · Accepted Answer · 2011-10-27 00:08:41Z

First ensure that MySQL Connector/NET is installed. Check all credentials are correct. Then try this snippet.

    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

Try this link, it's very straight forward.

Luís Cruz · Accepted Answer · 2015-05-14 13:05:44Z

-2

Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient
Public Class LoginForm1
    Dim mysqlconnection As MySqlConnection

    Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
        mysqlconnection = New MySqlConnection
        mysqlconnection.ConnectionString = "server=servername.com;port=portnum;user id=username ;pwd=password;database=databasename"
        'mysqlconnection.Open()
        Try
            mysqlconnection.Open()
        Catch myerror As MySqlException
            MsgBox("Error connecting to database!")
            Exit Sub
        End Try
        MsgBox("connected to database!")
    End Sub

edited May 14, 2015 at 13:05

Luís Cruz

15k16 gold badges71 silver badges100 bronze badges

answered May 14, 2015 at 11:22

reda al masry

1

1 Comment

MicroVirus Over a year ago

Welcome to StackOverflow. You have some formatting problems with your code. It's also usually desirable to add a little bit of text explaining your solution. You can edit your post to make these changes.

Collectives™ on Stack Overflow

Mysql Database connection vb.net

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related