Socket error when trying to connect to MYSQL on a remote Web server
Posted on 2007-07-31
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?