Connection problem

  • Thread starter Thread starter vovan
  • Start date Start date
V

vovan

Guest
My VB 6 program uses this connection string to connect to the server:
user id=coord;data source=GS;persist security
info=True;Password=coord;initial catalog=CoordinatorTest
It works fine on all XP machines, but it doesn't work on only some of Vista
Business machines. It says Server doesn't exists or access denied. On some
other Vistas it works.
When I replace the name of the SQL Server with IP:
user id=coord;data source=10.22.52.4;persist security
info=True;Password=coord;initial catalog=CoordinatorTest

then it works.

I wouldn't want to create the different Connection strings for different
operating systems.

What's wrong with some of non working Vista's machines? What should be done
in order to make all of Vista machines work?

Thank you
vovan
 
Re: Connection problem

"vovan" <v@v.com> wrote in message
news:%23v2T$CGEIHA.3332@TK2MSFTNGP04.phx.gbl...
> When I replace the name of the SQL Server with IP:
> user id=coord;data source=10.22.52.4;persist security then it works.

It sounds like your Vista machines can locate data sources by IP address,
but not by hostname. You'd want to troubleshoot this as a general TCP/IP
Name resolution problem - make sure DNS Settings are correct; does a "ping
<hostname> from an Vista Command Line give same results as "ping <IP
address>"?; etc.

The Netdiag tool from the XP Support Tools also runs on Vista; just copy
over the netdiag.exe file from XP. Then run

C:\FOO>netdiag /v /debug

on the Vista machine, to run a comprehensive test for DNS and Domain
problems.

You don't say whether you're using ODBC, OLE DB, SQL Native Client, or what;
but generally, they should all work on Vista much the same as on XP. More
likely to be networking than compatibility, I'd guess.

Hope it helps,
--
Andrew McLaren
amclar (at) optusnet dot com dot au
 
Back
Top