We are making some changes as we upgrade from SQL Server 6.5 to 2000. We use DSN for connectivity (VB Front end) and need to set Use ANSI Quoted Identifiers and ANSI Nulls, Paddings and Warnings to off....
MS says the client is set to 'on' by default...which is true. Does anyone have a way...
I'm sure you figured this out by now...but if not try using the IP Address instead of the alias/name
if you want to use the name, create entries in host and lmhosts files for the ip address and name.
Rod
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.