I am using Windows XP Service Pack 3. I set up a Firebird SQL server on a machine on my 5 computer local area network. I used to be able to access it by using the server name "Server-win7". Now, I need to use its IP address. I can access the database fine using the IP address of the machine, but this is not really a good solution. The IP addresses are not as intuitive as names and they are also dynamic unless I set them all up as static.
I don't know why the name/IP resolution no longer works. I have done nslookup and it tells me that my DNS server is outside my local network on a Verizon server somewhere and it provides the wrong address for my database server. I have used the Microsoft Network Monitor and I see that my requests to my server do get routed to that incorrect server that is not even on my LAN. It seems odd to me that Windows Explorer can still browse the network by computer name but other software cannot.
Do you have any idea why the local name resolution stopped working? How can I restore peace and harmony here on my LAN?
Thank you for your help.