Please try again later. The link below gives you a step by step which worked for me. It took me about a week to find the solution to the same problem and with many posts. I installed mySQL 4. But that’s not a good idea.

Uploader: Zulugami
Date Added: 19 June 2007
File Size: 41.67 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 99255
Price: Free* [*Free Regsitration Required]

It is not possible to create a new connection failed hy mysql odbc 5.

Here is the connection code I used to get my desktop application to work. I had an inbound rule set up that locked port down to be accessible only from a mmysql of IP addresses. End Try ‘ See if the connection state opened correctly successfully If mConnection. You were very right, the ISP cnonection blocked all ports but 21, 80 and Please, see Solution to Connecting remotely when you get Error post for details.


Nov 13, Especially if it’s on the MySQL default port. Boa tarde,Estou fazendo uma importao de um arquivo Excel. Please be thoughtful, detailed and courteous, and adhere to our posting rules.

I have then flushed privelages and it worked for me. This is NOT an effective connection failed hy mysql odbc 5.

Related Articles  PIRELLI DRG A225G DRIVERS

I have looked online and I understand one solution is to add skip-name-resolve to a my. MsgBox “Unable to connect due to the following error: Apr 12, First of all, it’s a very bad idea to have a worldwide open port to your database server.

TallTed 1 8. I have created a user account in the MySQL Administrator and faoled a host to enable remote access, I have also made an exception for my Windows Firewall on port but the connection still fails.

If you are going to access the database from another remote server, why don’t you place a file inside your site with some security such htpasswd protection or some authentication module I saw your post earlier in French, I apologize that my command of French is not enough for complex ideas, so I must rely on Google translate, and of course, my French is also not good enough to check the connevtion answer back from Google.

Please try again later.

MySQL – Connection Failed: [HY] [MySQL][ODBC Driver] Access denied for user

Check the mysql configuration: Not a programming related question, but anyway, check if the remote computer is able to connect to any other service running on the same computer you’re running the MySQL server. Post as a guest Name.


Sometimes you just don’t see the forest for the trees I hope it helps others out there. Last post Nov 13, After I have done the following upgrade I get the above connection failed hy mysql odbc 5.

[Mysql][ODBC Driver]host couldn’t connect [SOLVED] | DaniWeb

Connectjon Catch ex As Exception ‘Unable to connect. Difficulty Accessing Excel Spreadsheet Via Odbc 7z trying to access a spreadsheet on a network share. I restart the MySQL Service and check to see if I can connect to using the mysql consol in dos and it just won’t let me in, saying it can’t connect to mysql!

Can anyone tell me how can I resolve this issue. Firewalls are turned off Buenas, connnection que estoy trabajando en un proyecto sobre la plataforma. Site was running fine.