Specified SQL server not found.
If it happens to PC's that work sometimes an not other times, then it sounds
like a licensing problem.
If it's always the same PC's it sounds like an IP network problem.
Make sure you have the latest MDAC installed, and that "Driver=dbmsoccn" is
in your connect string.
As a diagnostic test try connecting to the IP Address and port of the SQL
server (i.e. don;t use DNS or WINS) if that works, then check your DNS/WINS
configuration on the PC's.
Regards,
DB
Quote:
> On an application that is connected to approx. 60 workstations
> sporadically we get the message as the application is trying to connect
> to the datasource. The application is VB6 and the db is SQL 7.0. We
> are connecting using the SQL OLE DB provider (Provider=SQLOLEDB.1) and
> coming in through a Trusted Connection. I have tried to change the
> Network Library to use the TCP/IP socket connectivity in the connect
> string to the Server. However, it fails as well indicating it cannot
> find the server as well.
> Our network is NT using sp 5(setup to use TCP/IP) and the clients are
> Windows 95.
