how do i connect to online mysql database in c# or VB

Question

3.00/5 (2 votes)

See more:

hi all

i want connect to online mysql database ...

i have this information :

PHPmyAdmin url like : 172.53.162.40/phpmyadmin (this is a url that i access all database
also user and pass for enter to this domain like:

User1 And Password1

database name : mygem
database user : uuu
password      : ppp

:::: NOW :::

and my host supporter say : not exists any port for access my database ...

i used from below code for connection string

string con="Server=172.53.162.40/phpmyadmin;Database=mygem;Uid=uuu;Pwd=ppp;";

but error accured ad say : can't connect to mysql host ....

How I Create Connection String For Connect to This Database ?

please help me

thanks a lot

Posted 9-Feb-13 10:00am

Esmaeil Ebrahimi

Updated 3-Apr-17 3:44am

Add a Solution

Comments

Bala Selvanayagam 9-Feb-13 17:28pm

Hope you have the database hosted in one of the ISP and you are trying to connect from your local windows application from your PC ?

It could be some times the ISPs would not allow connectivity from out side domain and will let you to connect from only their own domain space. could this be the reason why you are getting the "not exists any port for access my database" message ?

Sergey Alexandrovich Kryukov 26-Feb-13 19:52pm

Please stop posting non-answers as "solution". It can give you abuse reports which eventually may lead to cancellation of your CodeProject membership.
Comment on any posts, reply to available comments, or use "Improve question" (above).
Also, keep in mind that members only get notifications on the post sent in reply to there posts.
—SA

3 solutions

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)

Matej Hlatky · Answer 1 · 2013-02-09T10:39:00

Solution 1

Check http://www.connectionstrings.com/mysql[^], where you have examples how to compose conn. string for MySql.
Also make sure, you are using suitable solution, how to connect to MySQL from .NET - MySQL .NET connector[^].

Posted 9-Feb-13 10:39am

Matej Hlatky

Bala Selvanayagam · Answer 2 · 2013-02-09T21:05:00

There are few options and what is your requirement to have the remote server and connect from local windows applicaiton ? this is going to slow down your system ?

Option 1: l you may have to shop around for any providers who will enable remote access

Option 2: You can have your own dedicated server with the ISP so that you can have remote connectivity and this is expensive compared to option 1 which is shared server.

knocky2010 · Answer 3 · 2014-03-17T13:54:00

First of All you need to Download the MySQL odbc driver 3.51 driver from MySQL website if you are using MySQL. Then you need to enable Remote MySQL Access from your domain or website using your CPANEl Account...

You then use the MySQL ODBC 3.51 Driver to connect to your Remote Database using a Connection String from your VB.Net or C# Application.

Use this connection string

Server=myServerAddress;Database=mydbfile;Uid=myUsername;Pwd=myPassword;

myServerAddress website or domains address eg.www.yahoo.com
mydbfile is the name of the database you have created on you cpanel account that you have allowed remote access to and
myUsername and myPassword are the username and password that you will use to connect to your remote mysql Database...

For MS Access you can connect to your uploaded Access Database using an OLEDB connection .
For instance if your website is http://www.yahoo.com/db/mydbfile.mdb then you can use the Microsoft.Jet driver with this Connection String below; You need to Specify the password of your database if you have any...

VB

Dim DatabaseFile as string = ????
Dim connection_builder As New OleDb.OleDbConnectionStringBuilder
connection_builder = New OleDb.OleDbConnectionStringBuilder
connection_builder.DataSource = Me.mydbfile
connection_builder.Provider = "Microsoft.Jet.OLEDB.4.0"
connection_builder.Add("Jet OLEDB:Database Password", Password)
Return New Data.OleDb.OleDbConnection(connection_builder.ConnectionString)

That's it.. In Case you still have problems let me know...

how do i connect to online mysql database in c# or VB

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0