|12 Mar 2012||#1|
client machine using wrong network ID using ODBC ???
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 removed.com>' is blocked because of many connection errors; unblockwith 'mysqladmin flush hosts'
*not sure if this post should be in networking or whatever so plumped for general ??
|My System Specs|
|12 Mar 2012||#4|
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 Specs|
|Similar help and support threads for2: client machine using wrong network ID using ODBC ???|
|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|
|Whats Wrong With This Machine?||General Discussion|
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 05:50 PM.