Link to home
Start Free TrialLog in
Avatar of dimensionav
dimensionavFlag for Mexico

asked on

How to connect to a mySQL database in a remote (web hosted) server ?

HI

Considering the following question, I need to know how to connect to a MySQL database in a web hosted server and which would be the best connection string provider for windows (x64 x86, Server, XP and 7 ) using a vb.net application?



Thanks in advance
ASKER CERTIFIED SOLUTION
Avatar of mmorent
mmorent
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of dimensionav
dimensionav
Flag of Mexico image

ASKER

The MySQL is accesible using the port 3306, actually I have tried your connector and works only if I allow remote MySQL access on CPANEL using the Router IP but not if I use dyndns domain.
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image
It may be a firewall issue.
Avatar of dimensionav
dimensionav
Flag of Mexico image

ASKER

I have tried from a localhost with php (from the same IP) and I got this error:

Warning: mysql_connect() [function.mysql-connect]: Host 'MY IP' is not allowed to connect to this MySQL server in C:\AppServ\www\MYSITE\conndb.php on line 19

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in C:\AppServ\www\MYSITE\conndb.php on line 21
Error: Host ''MY IP' is not allowed to connect to this MySQL server

Perhaps I should check that with my hosting provider.
Regards.
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image
>Perhaps I should check that with my hosting provider.

Yes