You are here:

MS SQL Server/Retieving the Data from MySQL Server to Window Application Form

Advertisement


Question
I have to create window application in c#.net & MySql server

Mysql server is on remote host, Now I have to retrieve the data forn remote mysql server.
while connecting to localhost in this line server = "localhost" the dabase is connected but when connect remote mysql host by writing the IP like  server = "173.192.76.44"; its show the error :
Unable to connect to any of the specified MySQL hosts.

Answer
Hello Ranjana,

You can try connection strings details from this page:
http://www.connectionstrings.com/mysql/

The error means either the IP is not in the same network (not within reach) or there's something wrong with the query string. Is there any port in use on that server?

I would suggest to try best match for your need from the page mentioned above.

Feel free to follow-up.

Regards,

MS SQL Server

All Answers


Answers by Expert:


Ask Experts

Volunteer


Jwalant Natvarlal Soneji

Expertise

From general queries about SQL Severs both 2000 and 2005 to advanced features like Integration Services and Reporting Services.

Experience

Experience in the area: I have been working with database triggers, stored procedures, views, function, joins, dts, Query optimization. Education/Credentials: BE IT - 2005 Batch with First Class.

Publications
http://jwalantsoneji.com

Education/Credentials
BE IT, India

Awards and Honors
MCP

©2016 About.com. All rights reserved.