Vb.net Connect/net MySQL connection

Lance Johnson · 08-11-2006, 07:14 PM

Kinda web development....

This is my problem.

I have a MySQL database installed on my USB stick
This is so that i can work on my project at school which is horrible to connect to the internet, but it will be on the internet in the end

I have a program made in VB.net which should connect to the MySQL database via Connector/Net, but constantly gives me the error message

"Cannot connect to any of the specified MySQL hosts"

Code:

Imports MySql.Data.MySqlClient
------------------------------------------------------------------
Public Class frmlogin
    Dim conn As MySqlConnection

    Dim VarUser
    Dim VarPass

------------------------------------------------------------------
    Private Sub cmdlogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdlogin.Click
        conn = New MySqlConnection()
        conn.ConnectionString = "Server=localhost;Database=member;Uid=lance;""Pwd=test123;"
        Try
            conn.Open()
            MessageBox.Show("Connection Established to server")
            conn.Dispose()

There is a bit more to the code, but it isnt directly to do with connecting to the database, it is mostly to do with what the program does (secure login which is why i didnt post it up for obvious reasons)

When i try i do disable Firewalls (including windows firewall) and also Anti-virus but no luck...

I have made an attempt to connect to an online database with the same problem...

I am sure someone must know the solution, if you do please tell me.
As i am doing my nut on this one!

Thanks in advance
Lance

P.S
I can connect to the database via MySQL admin and add records to it via query browser. So i think there isnt a problem with the database...

08-11-2006, 07:14 PM	#1 (permalink) Top
Lance Johnson Geek Trainee Join Date: Nov 2006 Posts: 1 Status: Offline	Vb.net Connect/net MySQL connection Kinda web development.... This is my problem. I have a MySQL database installed on my USB stick This is so that i can work on my project at school which is horrible to connect to the internet, but it will be on the internet in the end I have a program made in VB.net which should connect to the MySQL database via Connector/Net, but constantly gives me the error message "Cannot connect to any of the specified MySQL hosts" Code: Imports MySql.Data.MySqlClient ------------------------------------------------------------------ Public Class frmlogin Dim conn As MySqlConnection Dim VarUser Dim VarPass ------------------------------------------------------------------ Private Sub cmdlogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdlogin.Click conn = New MySqlConnection() conn.ConnectionString = "Server=localhost;Database=member;Uid=lance;""Pwd=test123;" Try conn.Open() MessageBox.Show("Connection Established to server") conn.Dispose() There is a bit more to the code, but it isnt directly to do with connecting to the database, it is mostly to do with what the program does (secure login which is why i didnt post it up for obvious reasons) When i try i do disable Firewalls (including windows firewall) and also Anti-virus but no luck... I have made an attempt to connect to an online database with the same problem... I am sure someone must know the solution, if you do please tell me. As i am doing my nut on this one! Thanks in advance Lance P.S I can connect to the database via MySQL admin and add records to it via query browser. So i think there isnt a problem with the database...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can't connect my laptop to my tv???	BarrowBoy	Video Cards, Displays and TV Tuners	3	12-10-2005 09:08 PM
Hellllllllppppppppp Ftp Wont Connect	gdmwilson	Networking and Computer Security	15	24-08-2005 07:53 AM
connect 5.1 speakers to a pc	gazap	Sound Cards and Speakers	2	20-02-2005 12:34 PM
secure connect?	Jecht	Storage Devices	1	04-01-2005 06:11 AM
Canon Cam Can't Connect	krinks	Printers, Scanners and Digital Cameras	2	28-08-2004 02:14 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)