Link to home
Start Free TrialLog in
Avatar of gmbeckett
gmbeckett

asked on

Socket error when trying to connect to MYSQL on a remote Web server

I can connect to a MYSQL database on a Webserver from my local machine with the following connection string :
"Server=my webservers IP adress;Database=my database;user id=root;Password=my password;"

I am using VB.Net and referencing mysqdata.dll and Imports MySql.Data.MySqlClient

I hace put the same aspx file on my Web server and put the mysqldata.dll in the Bin directory.

But when I run the code on my remote Web Server and attempt to connect to the database I receive the following error:
A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied.

I have spent many hours searching the web for an answer but have not come up with a solution  

Has anyone any suggestions?
ASKER CERTIFIED SOLUTION
Avatar of m1tk4
m1tk4
Flag of United States of America 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 gmbeckett
gmbeckett

ASKER

Yes that worked, many thanks