SQL Connectivity

Last Post 09 Jun 2004 10:39 PM by satya. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mallannna
New Member
New Member

--
09 Jun 2004 09:38 PM
Can some one help on the connection problem we are facing.
We have recently upgraded our server from SQL 7 to SQL 2000. All the clients still have the SQL 7 Client Network Uitlity installed to gain access to our Server. Suddenly the clients are not able to connect to the server using an application. From the ODBC the connection to the server is established instantly but takes a very long time using the Application. With SQL 7 Client Network Uitlity the client is able to connect to our development server which is again SQL 2000. Even applying the SQL 2000 SP3a on the server is not helping. We tried installing the SQL 2000 Client Network Utility on one of the clients computers and now there is no problem connecting to our production server.
Can some one please help in telling what is the actual problem or do We have to install SQL 2000 Client Network Uitlity to all the clients ( over 300 of them)

Thanks & Rgds,
mallannna
satya
New Member
New Member

--
09 Jun 2004 10:39 PM
You cannot connect to SQL 2K server using SQL 7 client tools, all the clients must be upgraded to SQL 2K also.
Using SQL 2K client tools you can connection to SQL 7.
mallannna
New Member
New Member

--
10 Jun 2004 01:07 AM
Sorry Satya, but we are able to connect to a development server using the same application. And also there was no issue when we had a similar setup sometime ago. Even this problem started after a few days of upgradation. The end users were able to access for a few days. We are able to use SQL 7 Query analyzer and read data from SQL Server 2000.

satya
New Member
New Member

--
10 Jun 2004 10:52 PM
I;m amazed how you're able to connect SQL 2K using SQL 7 client tools, I never had success in performing such action.
You are not authorized to post a reply.

Acceptable Use Policy