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

Posted on 2007-07-31
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

    What happens if you use as the address when you run your code on the remote server?

    Author Comment

    Yes that worked, many thanks

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now