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
unityjon

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
Squirt

Windos 7 Ultimate 64 bit
 
 

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

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
unityjon

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
Thread Forum
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...
Virtualization
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
Create new network connection to FTP Client
Has anyone ever tried to change from XP to Vista, and create a new network connection to an FTP client? the "My Network" menu option has disapeared in both Vista and Win 7. The most logical choice therefore would be to look under Network for a menu option to do this. Nope.... Not there either. ...
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 22:23.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App