Very Computer

Hi All,

I am currently have the following problem where my calls
to the SQL Server 2000 is super slow if I have "Novell
Client for Netware" installed on my client PC.  My setup
is as follows:

Running a W2K Server with SQL Server 2000 installed on
it.  On my client machine I am running W2K Professional
with "Novell Client For Netware" installed on it.  I can't
remove "Novell Client For Netware" as I need access to my
Novell Network.

The problem is that when my application tries to connect
to SQL Server, it is very very very slow.   If I remove
the "Novell Client For Netware" from the client machine
then it speeds up and it can communicate with the SQL
Server with no problems.  With the "Novell Client For
Netware" installed, it can still communicate but it slows
down about 10 times or more.

My application uses ADO and OLE/DB to communicate with SQL
Server and I am using MDAC Version 2.6.

The client and server machines both have TCP/IP and
IPX/SPX network protocols installed for SQL Server.  
Initially, when SQL Server was installed on the Client and
Server they had Named Pipes and TCP/IP protocols installed
by default, but my application could not communicate until
I added the IPX/SPX protocol on the client machine's SQL
Server.

The following document from MS describes a slow connection
problem when using MDAC 2.6 and IP address instead of the
machine name (which we need to do because of our Novell
Network Setup), however, it doesn't seem to be exactly
this problem, since it suggests that this problem should
be occuring regardless of whether the novell drivers are
installed or not, which is not true in my case:
        http://support.microsoft.com/default.aspx?
scid=kb;EN-US;q300420

I would really appreciate any help or insight that anyone
can provide.

Regards
Iraj

You have PSS case open for this issue?  It seems research is under way.  
Seems to be something with the protocols.  I did not see another case like
this Good idea to post here in case others have seen it .  

This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! - www.microsoft.com/security

--------------------
| Content-Class: urn:content-classes:message


| Subject: SQL Server super slow when Novell Client For Netware is
installed on client PC
| Date: Mon, 6 May 2002 15:16:49 -0700
| Lines: 50

| MIME-Version: 1.0
| Content-Type: text/plain;
|       charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcH1S7fCIBBmv76TSCCUvcAZYqnhjA==
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TKMSFTNGXA10 10.201.226.38
| Path: cpmsftngxa07!cpmsftngxa09!cpmsftngxa08
| Xref: cpmsftngxa07 microsoft.public.sqlserver.server:210119
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi All,
|
| I am currently have the following problem where my calls
| to the SQL Server 2000 is super slow if I have "Novell
| Client for Netware" installed on my client PC.  My setup
| is as follows:
|
| Running a W2K Server with SQL Server 2000 installed on
| it.  On my client machine I am running W2K Professional
| with "Novell Client For Netware" installed on it.  I can't
| remove "Novell Client For Netware" as I need access to my
| Novell Network.
|
| The problem is that when my application tries to connect
| to SQL Server, it is very very very slow.   If I remove
| the "Novell Client For Netware" from the client machine
| then it speeds up and it can communicate with the SQL
| Server with no problems.  With the "Novell Client For
| Netware" installed, it can still communicate but it slows
| down about 10 times or more.
|
| My application uses ADO and OLE/DB to communicate with SQL
| Server and I am using MDAC Version 2.6.
|
| The client and server machines both have TCP/IP and
| IPX/SPX network protocols installed for SQL Server.  
| Initially, when SQL Server was installed on the Client and
| Server they had Named Pipes and TCP/IP protocols installed
| by default, but my application could not communicate until
| I added the IPX/SPX protocol on the client machine's SQL
| Server.
|
| The following document from MS describes a slow connection
| problem when using MDAC 2.6 and IP address instead of the
| machine name (which we need to do because of our Novell
| Network Setup), however, it doesn't seem to be exactly
| this problem, since it suggests that this problem should
| be occuring regardless of whether the novell drivers are
| installed or not, which is not true in my case:
|       http://support.microsoft.com/default.aspx?
| scid=kb;EN-US;q300420
|
| I would really appreciate any help or insight that anyone
| can provide.
|
| Regards
| Iraj

|
|
|

We had this problem and found the Novell client to blame.

We used client 4.83 when we had the problems, and
backtracked to client 4.81.

Novell have last week released SP1 for 4.83 which resolves
this issue.

Hope this helps

David Francis (CNE, MCP)