MS Server 2003 and SQL 7 -- sql server connect

John Smith
7/8/2003 8:54:29 AM

Quick question:

I have a Server 2003 box that I need's an ODBC connection to a NT 4 Server
box with SQL 7 on it for old legacy home grown apps. When I try to setup
the connection on the 2003 box, after selecting the SQL Server driver, it
only shows our SQL 2000 boxes and none of the SQL 7 boxes. I can type the
server name in that has SQL 7 on it, but it will not connect to it telling
me that the server does not exist.

Do I have to download a SQL 7 driver on the 2003 box? Any help would be
appreciated and let me know if I need to provide more details.

Thanks in advance,
Chris

John Smith
7/8/2003 9:00:54 AM

Here is the error message it gives me:

Connection failed:
SQLState: '01000'
SQL Server Error: 51
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(Connect()).
Connection failed:
SQLStae: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist of
access denied.

[quoted text, click to view]

sql server connect : MS Server 2003 and SQL 7