Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2007-07-31
Medium Priority
Last Modified: 2009-12-16
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?
Question by:gmbeckett
LVL 15

Accepted Solution

m1tk4 earned 2000 total points
ID: 19606222
What happens if you use as the address when you run your code on the remote server?

Author Comment

ID: 19606663
Yes that worked, many thanks

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question