Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ASE & MSSQL 7.0 via CIS

3 posts in Windows NT Last posting was on 2000-08-23 14:17:38.0Z
joanc Posted on 2000-08-22 15:09:35.0Z
From: joanc@else.com.pe
Date: Tue, 22 Aug 2000 11:09:35 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: ASE & MSSQL 7.0 via CIS
Message-ID: <6ED9A979500416C20053467685256943.0053468485256943@webforums>
Lines: 24
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1717
Article PK: 1089194

Hi,

I'm trying to connect my Sybase 11.9.2 to MS SQL Server 7.0 via CIS.

I have enabled CIS, created the remote server, created the external login,
but when i try to connect to the remote server an error occurs , the error
message is

Internal CT-Lib/Cs-Lib Error 840843974 'ct_connect(): netwrok packet layer:
internal net library error: Net Library operation terminate due to
disconnect.
Server Message: 11216

The configuration of SQL Server 7.0 is the default, i mean it allows remote
connections via RPC, and the default remote connections is 20.

Also i have prove to connect two ASE, and the connection is ok.

is there any seting that i forget?

please help me to solve this problem.

Thanks in advance

Joan Cáceres


Gordon R Sams Posted on 2000-08-23 14:17:38.0Z
Message-ID: <39A3DD02.5A057032@sybase.com>
Date: Wed, 23 Aug 2000 08:17:38 -0600
From: Gordon R Sams <gsams@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: joanc@else.com.pe
Subject: Re: ASE & MSSQL 7.0 via CIS
References: <6ED9A979500416C20053467685256943.0053468485256943@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 31
NNTP-Posting-Host: gsams-pc2.sybase.com 157.133.215.54
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1711
Article PK: 1089184

Joan,

In it's 7.0 release Microsoft decided to make changes to their tds such that a
DirectCONNECT is now needed between ASE/CIS and MS SS 7.0. You can open a case
with tech support to verify, but I believe the 12.0 DirectCONNECT Anywhere with
an odbc driver is needed between ASE/CIS and MS SS 7.0, whereas with 6.5 the
two could communicate directly.

Gordon

joanc@else.com.pe wrote:

> Hi,
>
> I'm trying to connect my Sybase 11.9.2 to MS SQL Server 7.0 via CIS.
>
> I have enabled CIS, created the remote server, created the external login,
> but when i try to connect to the remote server an error occurs , the error
> message is
>
> Internal CT-Lib/Cs-Lib Error 840843974 'ct_connect(): netwrok packet layer:
> internal net library error: Net Library operation terminate due to
> disconnect.
> Server Message: 11216
>
> The configuration of SQL Server 7.0 is the default, i mean it allows remote
> connections via RPC, and the default remote connections is 20.
>
> Also i have prove to connect two ASE, and the connection is ok.
>
> is there any seting that i forget?
>
> please help me to solve this problem.
>
> Thanks in advance
>
> Joan Cáceres


Wayne Duquaine Posted on 2000-08-22 18:15:31.0Z
Message-ID: <39A2C343.2ED3@sonic.net>
Date: Tue, 22 Aug 2000 11:15:31 -0700
From: Wayne Duquaine <grandvu@sonic.net>
Reply-To: grandvu@sonic.net
Organization: Grandview
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: Re: ASE & MSSQL 7.0 via CIS
References: <6ED9A979500416C20053467685256943.0053468485256943@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 79
NNTP-Posting-Host: d88.pm9.sonic.net 208.201.230.88
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1715
Article PK: 1089188

Joan:

I have been burned by this multiple times at multiple customers.

You are being victimized by the Sybase / Microsoft divorce.
Sybase and Microsoft clients and servers use a database
application level protocol called TDS (TaBular Datastream)
to communicate SQL and RPC requests from clients to servers,
and to return replies or results sets from the servers to
the clients. Originally both Sybase and Microsoft used a common
version of TDS called TDS version 4.2.

After the divorce, each company ended up extending TDS is
new and different (and occasionally incompatible) ways.
Sybase created TDS version 5.0 (used in SQL Server 10, 11, 12)
and Microsoft created TDS version 7.0 (used in SQL Server 7.0 and
parts of SQL 2000).

What is happening in your specific case, is that Sybase SQL Server 11
is sending a TDS 5.0 login to Microsoft's SQL 7.0 which is expecting
a TDS 7.0 login. When SQL Server 7.0 barfs on the login, it
closes the connection and the result is the "terminate due to
disconnect"
error message that you are seeing.


The good news (most of the time)
--------------
This problem in 90 % of the cases can be solved by upgrading SQL Server
7.0
to Service Pack 2. In particular, you need to have new versions of
opends60.dll and ums.dll in the MSSQL\binn directory. These must be
dated 02/08/00 or later.

What this sevice pack does, is it negotiates the TDS protocol down to
the "common subset" (TDS 4.2) that is still supported by both vendors
for compatibility reasons.


The bad news
------------
Some versions of 11.x ct-lib still fail, even with the new
fix pack version from Microsoft. I have yet to understand why,
and I am tired of running TDS traces to find out what Sybase's problem
is
(yes, Sybase is the culprit in those situations).

The other problem that the fixed version from Microsoft does not solve
is that trying to send native "Decimal" or "Numeric" data types between
Sybase and Microsoft almost always fails, because TDS 4.2 did not
natively support those data types. So if you need to exchange
Decimal/Numeric
data between them, you will need to specify CONVERT(xxxx) for those
columns
or parameters, to convert them to a format that is compatible between
the
two systems (e.g. FLOAT or MONEY).

joanc@else.com.pe wrote:
>
> Hi,
>
> I'm trying to connect my Sybase 11.9.2 to MS SQL Server 7.0 via CIS.
>
> I have enabled CIS, created the remote server, created the external login,
> but when i try to connect to the remote server an error occurs , the error
> message is
>
> Internal CT-Lib/Cs-Lib Error 840843974 'ct_connect(): netwrok packet layer:
> internal net library error: Net Library operation terminate due to
> disconnect.
> Server Message: 11216
>
> The configuration of SQL Server 7.0 is the default, i mean it allows remote
> connections via RPC, and the default remote connections is 20.
>
> Also i have prove to connect two ASE, and the connection is ok.
>
> is there any seting that i forget?
>
> please help me to solve this problem.
>
> Thanks in advance
>
> Joan Cáceres