I am writing a dotnet app that needs to connect to SQL 2000. I have used the
imports system.data.SqlClient. I have tried everything I can think of but I
constantly get an error when it tries to connect to the server.

"An error has occurred while establishing a connection to the server.
(provider:Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)

Could you show us your connection string, seems that you are using
named pipes for some reason (perhaps TCPIP is disabled at the client or
server). make sure that if you want to use TCPIP that on both the
client and the server the same protocol is enabled.

HTH, jens Suessmeyer.

---
http://www.sqlserver2005,de
---