How do i connect vb.net 10 form to the online database

Question

0.00/5 (No votes)

See more:

Hello,

I wanted my windows form to be connected to the online database,
I mean I have a mysql database on phpmyadmin, on my hosting provider.
I am creating a windows form that must get data from this database.

i downloaded and installed the connector, and used a code to connect to the data base but i get a error that says "Unable to connect to any of the specified MySQL hosts.

What I have tried:

Imports System.Data.SqlClient
Imports MySql.Data.MySqlClient

Public Class Form1
Dim con As New MySqlConnection
Dim cmd As New MySqlCommand

Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "server=localhost;port=3306; user id=myuserid; password=mypassword; database=mydatabasename"
con.Open() 'Error is in this line
cmd.Connection = con

Dim adp As New MySqlDataAdapter
Dim ds As New DataSet
cmd.CommandText = "Select fname from table_name where name='xyz'"
Me.TextBox1.Text = ToString(cmd.ExecuteScalar)
End Sub
End Class

I am sorry if I am not clear in any basis, but i need help

Posted 27-Feb-16 1:49am

Member 12355491

Updated 27-Feb-16 2:09am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-02-27T02:09:00

localhost is for databases on the same machine only - most hosting services separate the database and web servers (or more usually have a database server farm) so you need to talk to them about exactly what the connection string should be. Only they can tell you, as it will need the SQL server name, together with your DB username and password - and these will be different for every hosting service.
Just to make life even more fun, you will need to check if the hosting service allows "remote connections" - some do, but many don't for security reasons. If they don't, then you can only access the DB from the website server code - not from a remote PC application.