Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mallikarjuna_
Starting Member
20 Posts |
 Posted - 2004-06-10 : 02:30:08
|
| 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,Mallikarjuna |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-10 : 02:41:59
|
| Check out the Client Configuration in the ODBC DSN setupThis allows you to set the network protocols. Ensure that the ones specified on the client PC's are 'enabled' on the server. |
 |
|
|
mallikarjuna_
Starting Member
20 Posts |
Posted - 2004-06-10 : 03:19:11
|
| Thnks for the reply these things are already checked. But the problem still persists. |
|
|
|
|
|
|
Connectivity