For some reason I cannot get this to work at the office. Can someone see the problem?
I have the following
DataSet ds = new DataSet();
MySqlCommand myCommand = new MySqlCommand("SELECT MoveID, MovieName FROM Movies");
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionStrin
myCommand.CommandType = CommandType.Text;
myCommand.Connection = oMySqlConn;
try
{
myCommand.Connection.Open(
MySqlDataAdapter da = new MySqlDataAdapter(myCommand
da.Fill(ds);
}
finally
{
myCommand.Connection.Close
}
I then get the following error
Additional information: 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
If I change the server to be . or localhost I get
Additional information: Unable to connect to any of the specified MySQL hosts
I have now written the entire application without being able to test... if I can get this to connect I should be done
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I removed the pooling, tried the IP
It's running locally so I tried 127.0.0.1 and 10.2.52.26 and (localhost) and localhost....
Something weird is going on here..... From what I can find this problem happens when people try to connect to remote computers.
Does anyone know what else you can call you local machine for me to try?
GavinMannion,
I'm just throwing out a guess, but I checked www.connectionstrings.com and saw the reference to the server is with the Data Source property:
"Data Source=server;Database=myd
Maybe that would do it? Good luck!
-- Jason
Another shot.. is your mySql server running on the standard port? If you have changed the port number you need to take this into consideration?
Also, can you connect to the database using a standard ODBC DSN entry and the "Test Data Source" facility that is provided with this?
If that works you could possible set up your application to use a DSN=xxx connection string instead of trying to connect directly.
Just a few ideass that might help.
Gary Francis
Software Developer
http://www.ssil.co.uk
Business Accounts
Answer for Membership
by: DarkXiphoidPosted on 2006-09-06 at 03:17:41ID: 17461852
Try removing pooling=false from your connection string, and try to get the IP adress of the server instead of it's name.
The basic idea is to strip the connection of constraints until it works, and then rebuild the constraints you need to see what is wrong.