Very slow response from SQL Server 6.5 on a network with both Netware/Microsoft Clients 
Author Message
 Very slow response from SQL Server 6.5 on a network with both Netware/Microsoft Clients

Hi,

our program (back-end: SQL-Server 6.5, front-end ACCESS 97) gets very
slow response when used on WIN 95 client machines with active netware
and Microsoft NT Server connections.

The same program used in the same environment works ok when used on a
NT workstation machine with only Microsoft network client software
installed.

What goes wrong on the WIN 95 machines with both Netware and Microsoft
network client software ?

Many thanks in advance for your help,

Cheers, Bernd.




Sat, 20 Oct 2001 03:00:00 GMT
 Very slow response from SQL Server 6.5 on a network with both Netware/Microsoft Clients

Bernd,

Quote:
> Subject: Very slow response from SQL Server 6.5 on a network with both Netware/Microsoft Clients

Q.     Why do I get slow or no connections to SQL Server using IPX from my Win3x and Win9x
clients?  From Windows NT they work fine.
(v1.0  12.1.1999)

A. This is because of a network feature called "direct hosting".  To resolve the problem either
use another protocol completely or turn off the feature.  On the NT Server this can be done by
disabling the NWLink IPX/SPX binding in Windows NT Server service.  After this is done, enable
NWLink with NetBIOS on the client computer.

Alternatively you can turn it off at the client end.  For Windows 3x machines this can be done by
editing the system.ini file and amending/adding the following entry.

   [network]
   DirectHost=off

For Windows 95 use regedit.exe to navigate to the following registry key:

      HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\VxD\VNETSUP

Add a string value named DirectHost and set the string value to 0 (zero). Also, ensure that
NetBIOS support is enabled for NWLink, if NWLink is the only transport protocol loaded on the
client computer running Windows 95.

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please post ALL replies to the newsgroup only unless indicated otherwise)
 For SQL FAQ entries see
 http://go.compuserve.com/sqlserver (library 1) - latest stuff is always here
 www.ntfaq.com/sql.html
 http://www.swynk.com/faq/sql/sqlserverfaq.asp



Sat, 20 Oct 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Very slow response from SQL Server 6.5 with ACCESS 97 client

2. Very slow response from SQL Server 6.5 with ACCESS 97 client

3. SQL Server super slow when Novell Client For Netware is installed on client PC

4. SQL Server super slow when Novell Client For Netware is installed on client PC

5. SQL Server super slow when Novell Client For Netware is installed on client PC

6. SQL Server super slow when Novell Client For Netware is installed on client PC

7. Compaq Deskpro (Win95) + ODBC (2.5 16bit) + SQL Server (6.5) = Slow Response

8. Very slow response from SQL Server 6.5 with ACCESS 97 frontend

9. Compaq Deskpro (Win95) + ODBC (2.5 16bit) + SQL Server (6.5) = Slow Response

10. Microsoft Sql Server Training : Hands-On, Self-Paced Training for Microsoft Sql Server Version 6.5

11. Microsoft Sql Server Training : Hands-On, Self-Paced Training for Microsoft Sql Server Version 6.5

12. Microsoft Sql Server Training : Hands-On, Self-Paced Training for Microsoft Sql Server Version 6.5


 
Powered by phpBB® Forum Software