Hi all, I have a problem. I have several bespoke applications that I have built and maintain across a small company of 35 people.
I have a user who cannot connect to a SQL Server 2008 using an ADO Connection, if it uses a host name. This is specific to the user and computer. If the user logs onto another computer, they do not have an issue and the connection string works fine. If another user logs onto their connection, the ADO connection also works fine. To clarify what I mean by "If it uses a host name", if the connection string is: "ODBC;DRIVER=SQL Server;SERVER=SQL1;" (etc) it does not work, but if I use the IP address of the server, ie, "ODBC;DRIVER=SQL Server;SERVER=192.168.2.102;" it works. I have modified the hosts file and lmhosts.sam file to point SQL1 to the IP Address, and I am able to ping SQL1 to get the IP address. I can also access this server from the computer. Any previous experience or help on this would be appreciated Thank you Mike
