how to access web MySQL database in vb.net desktop app?

Question

0.00/5 (No votes)

See more:

hello guys,

please help...
i haven't had any idea on how to make this app?
but does anyone have encountered like this?
a simple desktop that connects to the web database of a website...

thanks in advance..

Posted 31-Dec-10 21:17pm

jleonorlane

Add a Solution

2 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)

dmageiras · Answer 1 · 2011-01-01T00:00:00

Solution 1

Download and install MySqlConnector. This provides a set of classes that allow you to perform database operations on MySql.
Hope this helps.

Posted 1-Jan-11 0:00am

dmageiras

thatraja · Answer 2 · 2011-01-01T00:38:00

Solution 2

It's just thing about connection string man. Just change the servername with Remote machine's Host name or IP address in connectionstring. That's all.

The VB.NET-MySQL Tutorial – Part 5[^]

Attachments

www.connectionstrings.com/mysql[^]

How Do I Enable Remote Access To MySQL Database Server?[^]

Posted 1-Jan-11 0:38am

thatraja

Comments

jleonorlane 4-Feb-11 10:17am

..thanks thatraja, what i have done now is ,i have try first to connect using the SQLyog SSH Tunnel.
And i had successfully connect to the database of my website.
But my desktop app can't connect to the website database.Do i have to put an SSH feature to my app, for me to connect to my website's database?

Nilesh Makavana 13-Oct-11 1:47am

hello
how can i connect to database when the free hosting database
it's possible that free web hosting database that can i use in my vb.net desktop application.
i used vb2010
i able to connect to my local host but i can't connect to my web host
database