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:

Quote:
Connection failed:[HY000][MSQL][ODBC 3.51 DRIVER] Host 'WRT2012.<domain name removed.com>' 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 192.168.0.2_

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

 client machine using wrong network ID using ODBC ???




Thread Tools



Similar help and support threads for2: client machine using wrong network ID using ODBC ???
Thread Forum
Admin Permissions - Many Problems on Client Windows 7 Pro x64 Machine General Discussion
How do i ignore UAC prompts in App-V client machine Virtualization
windows 7 client and 2003 server: network Slow in very big Network !! Network & Sharing
Network Discovery and DNS client service Network & Sharing
Whats Wrong With This Machine? General Discussion
client machine granting on mac Network & Sharing

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 03:42 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33