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

x
?
Solved

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

Posted on 2007-07-31
2
Medium Priority
?
246 Views
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?
0
Comment
Question by:gmbeckett
2 Comments
 
LVL 15

Accepted Solution

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

Author Comment

by:gmbeckett
ID: 19606663
Yes that worked, many thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

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