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

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.

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...

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...