Hi, I modified the LMhost file on a recommendation that it might fix it.. it didn't. The DNS is working fine, and the user can ping from the machine and have it resolve the name correctly. The issue only occurs when an ADO connection is used..
Thanks for your reply Mike On 29 Oct, 18:51, KeidrickP <[EMAIL PROTECTED]> wrote: > check the DNS on the machine that you are having issues connecting with. > Why are you using LMhost files? This is considered "legacy" or an obselete > technology. > > On Wed, Oct 29, 2008 at 11:29 AM, KoldKay <[EMAIL PROTECTED]> wrote: > > > 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
