Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: client machine using wrong network ID using ODBC ???

12 Mar 2012   #1

windows7 professional
client machine using wrong network ID using ODBC ???

HI all,

First post, i've been searching but wording this in a way similar to someone else has beaten me thus far.....

I have a windows7 client that was initially called wrt2012 on our domain, i renamed the machine to wr5 when i was happy it was working ok (it was my guniea pig machine !) but now when i try to establish an ODBC connection to an SQL server i get the following error:

Connection failed:[HY000][MSQL][ODBC 3.51 DRIVER] Host 'WRT2012.<domain name>' is blocked because of many connection errors; unblockwith 'mysqladmin flush hosts'
Can someone explain where this is broadcasting the machine name WRT2012, i.e the old client name from so i can delete it ?

*not sure if this post should be in networking or whatever so plumped for general ??

My System SpecsSystem Spec
12 Mar 2012   #2

Windos 7 Ultimate 64 bit

Check your DHCP client on the domain cotroler.
My System SpecsSystem Spec
12 Mar 2012   #3

windows7 professional

Quote   Quote: Originally Posted by Squirt View Post
Check your DHCP client on the domain cotroler.
We dont use Dynamic Hosting as there are only 6 clients and 3 servers, the issue seems to be generated from this client machine
My System SpecsSystem Spec

12 Mar 2012   #4

windows7 professional
Fixed it !

I've fixed it, it wasn't actually a windows7 error <phew> but looking around the net lots of people are reporting this error so here's what i found.....

I used mysqladmin and ran te flush-hosts command to reset the failed connection attempts, this alone didn't work, but whilst browsing mysqladmin i noticed that under my username it had an ip registered

When i built the windows7 clients i used so i added to my username hosts and hey presto i'm in !
My System SpecsSystem Spec

 client machine using wrong network ID using ODBC ???

Thread Tools

Similar help and support threads
Thread Forum
Connecting VM machine from another Machine in same network
Hi, Hope you all doing good !! Am trying to connect my vm machine on a host server from another machine in the same network, however its not successful. Below are the details: Host machine- win 7 IPv4: gateway-
Network & Sharing
How do i ignore UAC prompts in App-V client machine
Hi all This is my first thread in Win7Forum. I virtualized Gliem's TestPrep application using Microsoft App-V Sequencer and created the necessary files to install it in client machine.There is only one entry point(shortcut) for this app. After successful installation of this app in the...
windows 7 client and 2003 server: network Slow in very big Network !!
hello engineers, how r yo all? Guys i need your help. My problem is windows 7 hangs and freeze when access 2003 server Enterprise edition . This is not a small network, one of the biggest network. i have doubt on individual users...
Network & Sharing
Desktop FTP Client - Map Network Drive
Here is a simple tutorial on how to create your very own Desktop FTP Client using the "Map Network Drive" in "My Computer" that will allow full access to your hosting account instead of using cPanel 11 or simular. You can also drag/drop all your files/folders straight into your "Public_HTML" folder...
Network & Sharing
Whats Wrong With This Machine?
My dad and I went to get some soda, (I'm Addicted To Caffeine) So my dad turns on this machine and said wtf? Well... Here is a video to go along with it. Go to this link for me>>> GxF5bY-H3eA
General Discussion

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 07:07.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App