• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1069
  • Last Modified:

Unable to connect to any of the specified MySQL hosts

I am trying to connect from Integration Services 2008 to a database in MySQL 5.1. The steps are actually
1. Install the driver for MYSQL. NET
2. Enter the appropriate data and I can not connect, I get the error: Unable to connect to Any of the specified MySQL hosts.
connecMysql.JPG
0
enrique_aeo
Asked:
enrique_aeo
  • 2
  • 2
2 Solutions
 
Reza RadConsultant, TrainerCommented:
did you check the PORT in ALL tab? is it correct?
0
 
SoLostCommented:
Are you allowed to connect from your IP Address for user root?

Do you have something else like MySQL Query Browser or WorkBench that connects successfully using root from your PC?
0
 
enrique_aeoAuthor Commented:
how to find the port in a mySQL database?

Are you allowed to connect from your IP Address for user root? = as I can do?
0
 
enrique_aeoAuthor Commented:
The port is configured in the Integration Services is 3306 and coincides with the server, MySQL database
Finally, I have 2 errors: 1. When I click the combo list database: disable to retrieve the list (see image) 2. Click the Test Connection button: I get error with the provider
mySql-click-button-test-connecti.JPG
mySql-click-dropdownList.JPG
0
 
Reza RadConsultant, TrainerCommented:
is the mysql database on the machine you develop this ssis package?
if not could you check that could you connect to mysql server with this information from a php page or something like this?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now