We have just installed a new server that is supposed to function primarily
as an IIS server. I am experiencing a few problems configuring ODBC connections
from this IIS server to our database servers. I am able to make an ODBC
connection to an old SQL 6.5 box only after mapping a drive from this new
IIS server to the drive where the 6.5 MASTER db resides, and I cannot connect
at all to our new 2000 SQL box. The error I'm getting is

"Connection failed:
SQLState: 01000
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (CreateFile()).
Connection failed:
SQLState: 08001
SQL Server Error: 1326
[Microsoft][ODBC SQL Server Driver]Client unable to establish connection"

We are running two named instances on the new SQL 2000 server without any
default instance installed. I have tried to connect both with named pipes
and TCP/IP.

How do you update the SQL Server ODBC driver? It may be out of date.


Does anyone have any ideas what may be causing this problem?

Thanks,

Terry