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.

ODBC Connection Errors

5 posts in Windows NT Last posting was on 2001-02-01 21:18:17.0Z
glenmaroney Posted on 2000-12-04 16:58:54.0Z
From: glenmaroney@breathe.com
Date: Mon, 4 Dec 2000 11:58:54 -0500
Newsgroups: sybase.public.sqlserver.nt
Subject: ODBC Connection Errors
Message-ID: <595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums>
Lines: 18
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1430
Article PK: 1088902

I have been reading the Sybase.com support site and have come up with a
seemingly common problem which I am experiencing.

I am using a VB6 application to talk to Sybase system 10 (Version 10.0.3T4)
via ODBC
(DAO360) but am getting the following error message:

"[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): network
packet layer:
internal net library error: Net-Library operation terminated due to
disconnect."

The error is intermittent as some connections succeed whereas others do
not!
Does anyone know what this means or can anyone offer a solution?

Many thanks

Glen


Heko Posted on 2001-01-24 14:14:29.0Z
From: "Heko" <haile@uol.com.ar>
References: <595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums>
Subject: Re: ODBC Connection Errors
Date: Wed, 24 Jan 2001 11:14:29 -0300
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <yfvesJhhAHA.316@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: venus.tis.com.ar 63.69.231.252
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1286
Article PK: 1088753

We´re having the same problem here, and we could not find any answer yet.
Did anyone find a workaround for this issue?

<glenmaroney@breathe.com> wrote in message
news:595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums...
> I have been reading the Sybase.com support site and have come up with a
> seemingly common problem which I am experiencing.
>
> I am using a VB6 application to talk to Sybase system 10 (Version
10.0.3T4)
> via ODBC
> (DAO360) but am getting the following error message:
>
> "[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): network
> packet layer:
> internal net library error: Net-Library operation terminated due to
> disconnect."
>
> The error is intermittent as some connections succeed whereas others do
> not!
> Does anyone know what this means or can anyone offer a solution?
>
> Many thanks
>
> Glen


Jim Gould Posted on 2001-01-19 02:50:16.0Z
From: "Jim Gould" <jim.gould@home.com>
References: <595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums>
Subject: Re: ODBC Connection Errors
Date: Thu, 18 Jan 2001 20:50:16 -0600
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <d1dVsScgAHA.216@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: cb555575-a.mdsn1.wi.home.com 24.10.219.209
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1291
Article PK: 1088757

I am receiving the same error after adding a new database to my v11x server.
Have contacted a consultant and will update when I have an answer.

<glenmaroney@breathe.com> wrote in message
news:595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums...
> I have been reading the Sybase.com support site and have come up with a
> seemingly common problem which I am experiencing.
>
> I am using a VB6 application to talk to Sybase system 10 (Version
10.0.3T4)
> via ODBC
> (DAO360) but am getting the following error message:
>
> "[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): network
> packet layer:
> internal net library error: Net-Library operation terminated due to
> disconnect."
>
> The error is intermittent as some connections succeed whereas others do
> not!
> Does anyone know what this means or can anyone offer a solution?
>
> Many thanks
>
> Glen


Jason Froebe Posted on 2001-01-24 15:39:36.0Z
Message-ID: <3A6EF738.7021EF2C@sybase.com>
Date: Wed, 24 Jan 2001 09:39:36 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.18 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Jim Gould <jim.gould@home.com>
Subject: Re: ODBC Connection Errors
References: <595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums> <d1dVsScgAHA.216@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------BC5FCA05E0EE06D1D716650F"
Newsgroups: sybase.public.sqlserver.nt
Lines: 49
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1285
Article PK: 1088752


Jim Gould wrote:

> I am receiving the same error after adding a new database to my v11x server.
> Have contacted a consultant and will update when I have an answer.
> <glenmaroney@breathe.com> wrote in message
> news:595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums...
> > I have been reading the Sybase.com support site and have come up with a
> > seemingly common problem which I am experiencing.
> >
> > I am using a VB6 application to talk to Sybase system 10 (Version
> 10.0.3T4)
> > via ODBC
> > (DAO360) but am getting the following error message:
> >
> > "[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): network
> > packet layer:
> > internal net library error: Net-Library operation terminated due to
> > disconnect."
> >
> > The error is intermittent as some connections succeed whereas others do
> > not!
> > Does anyone know what this means or can anyone offer a solution?
> >
> > Many thanks
> >
> > Glen

Hi Jim,

Can you enable ODBC trace and post the output to the newsgroup for a failing
connection?

j


Download VCard jfroebe.vcf


Jim Gould Posted on 2001-02-01 21:18:17.0Z
From: "Jim Gould" <jim.gould@uwmf.wisc.edu>
References: <595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums> <d1dVsScgAHA.216@forums.sybase.com> <3A6EF738.7021EF2C@sybase.com>
Subject: Re: ODBC Connection Errors
Date: Thu, 1 Feb 2001 15:18:17 -0600
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <QdEIabJjAHA.290@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 144.92.250.90
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1257
Article PK: 1088717

I found the answer, at least in my situation:

Used sp_configure and checked the number of user connections. Mine was set
to 50. I had added a third database and so effectively increased my user
connections by 1/2, (1 connection per user per database.) I upped my user
connections to 100, and have not seen the error since. Be careful, though,
depending on system resources, setting this too high can cause things like
database dumps, etc. to fail. The System Administrators Guide explains this
at length. I remember seeing a formula somewhere for determing a safe
number. Hope this helps someone. I've found lots of answers here without
ever posting a question. Thanks....

"Jason Froebe" <jfroebe@sybase.com> wrote in message
news:3A6EF738.7021EF2C@sybase.com...
> Jim Gould wrote:
>
> > I am receiving the same error after adding a new database to my v11x
server.
> > Have contacted a consultant and will update when I have an answer.
> > <glenmaroney@breathe.com> wrote in message
> > news:595D38F809FCA0B4005D4885852569AB.005D4895852569AB@webforums...
> > > I have been reading the Sybase.com support site and have come up with
a
> > > seemingly common problem which I am experiencing.
> > >
> > > I am using a VB6 application to talk to Sybase system 10 (Version
> > 10.0.3T4)
> > > via ODBC
> > > (DAO360) but am getting the following error message:
> > >
> > > "[INTERSOLV][ODBC SQL Server driver][SQL Server]ct_connect(): network
> > > packet layer:
> > > internal net library error: Net-Library operation terminated due to
> > > disconnect."
> > >
> > > The error is intermittent as some connections succeed whereas others
do
> > > not!
> > > Does anyone know what this means or can anyone offer a solution?
> > >
> > > Many thanks
> > >
> > > Glen
>
> Hi Jim,
>
> Can you enable ODBC trace and post the output to the newsgroup for a
failing
> connection?
>
> j
>