I am author of a Visual Basic program which reads data from a SQL DB. This program works fine on some workstations, but not others. I get the following error:

Run-time error '-2147467259(80004005)':
[DBNMPNTW]Specified SQL server not found.

My research so far as led me to check the SQL client config of the workstations in question by running CLICONFG.EXE and changing from Named Pipes to TCP\IP. When I do this the error message becomes:

Run-time error '-2147467259(80004005)':
[DBMSSOCN]General network error. Check your network documentation.

All of the workstations in question, those which run the program fine, and those that do not are Windows 2000 with service pack 4. I have noticed that the file version of CLICONFG.EXE is 1999.10.20.1 on the machines that have the error, and 2000.80.380.0 on the machines that work fine.

Have you seen this, and can you point me towards a solution? Can the problem be solved in the VB code, or does the workstation need to upgraded?

Thanks in advance for any advice you can send my way.



Andrew Duffy-Peter

I am running into same problem, except os is XP Pro. Did you find an answer yet? Thanks.