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.

native error -85

8 posts in General Discussion Last posting was on 2005-01-26 03:44:26.0Z
Roger Posted on 2005-01-18 16:20:41.0Z
From: "Roger" <Roger.J.Halbur@emcins.com>
Newsgroups: ianywhere.public.general
Subject: native error -85
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 209.37.78.5
Message-ID: <41ed3755$1@forums-2-dub>
X-Original-Trace: 18 Jan 2005 08:20:37 -0800, 209.37.78.5
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Jan 2005 08:20:38 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Jan 2005 08:20:41 -0800
X-Trace: forums-1-dub 1106065241 10.22.108.75 (18 Jan 2005 08:20:41 -0800)
X-Original-Trace: 18 Jan 2005 08:20:41 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4070
Article PK: 7956

Hi,

I am receiving this error on a Window Terminal Server 2003 running Citrix
MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526



ODBC Error: Function :SQLFetch returned SQL_ERROR with state 08S01 native
error -85 RowCount=-2 NumResultCols=64 NumParams=0

[Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link failure:
Communication error

Here is some more errror Info

ODBC Information:
SQL Ver: SA70
Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE 7\WIN32\dbodbc7.dll
Description: SQL
EngineName: SQLSERVER
CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
DatabaseName: SQL70
AutoStop: Yes
Start:

Any ideas would be helpfull.

Thanks,
Roger


Robert Waywell Posted on 2005-01-19 15:25:10.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41ed3755$1@forums-2-dub>
Subject: Re: native error -85
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <41ee7bd2$1@forums-2-dub>
X-Original-Trace: 19 Jan 2005 07:25:06 -0800, rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Jan 2005 07:25:07 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Jan 2005 07:25:10 -0800
X-Trace: forums-1-dub 1106148310 10.22.108.75 (19 Jan 2005 07:25:10 -0800)
X-Original-Trace: 19 Jan 2005 07:25:10 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4077
Article PK: 7961

This error indicates that the application has lost the connection to the
database server.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Roger" <Roger.J.Halbur@emcins.com> wrote in message
news:41ed3755$1@forums-2-dub...
> Hi,
>
> I am receiving this error on a Window Terminal Server 2003 running Citrix
> MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526
>
>
>
> ODBC Error: Function :SQLFetch returned SQL_ERROR with state 08S01 native
> error -85 RowCount=-2 NumResultCols=64 NumParams=0
>
> [Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link failure:
> Communication error
>
> Here is some more errror Info
>
> ODBC Information:
> SQL Ver: SA70
> Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE 7\WIN32\dbodbc7.dll
> Description: SQL
> EngineName: SQLSERVER
> CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
> DatabaseName: SQL70
> AutoStop: Yes
> Start:
>
> Any ideas would be helpfull.
>
> Thanks,
> Roger
>
>


Roger Posted on 2005-01-19 15:54:21.0Z
From: "Roger" <Roger.J.Halbur@emcins.com>
Newsgroups: ianywhere.public.general
References: <41ed3755$1@forums-2-dub> <41ee7bd2$1@forums-2-dub>
Subject: Re: native error -85
Lines: 76
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 209.37.78.5
Message-ID: <41ee82aa$1@forums-2-dub>
X-Original-Trace: 19 Jan 2005 07:54:18 -0800, 209.37.78.5
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 19 Jan 2005 07:54:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 19 Jan 2005 07:54:21 -0800
X-Trace: forums-1-dub 1106150061 10.22.108.75 (19 Jan 2005 07:54:21 -0800)
X-Original-Trace: 19 Jan 2005 07:54:21 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4078
Article PK: 7963

Thanks, for the answer. I did how ever figure that part out. What I am
looking for is a way to keep the application from loosing the connection.
Is there some thing that can be added to the ODBC setting or the server or
anything that will force it to keep connected? I am not the developer of
the application that is loosing connection.

Roger

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:41ee7bd2$1@forums-2-dub...
> This error indicates that the application has lost the connection to the
> database server.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> news:41ed3755$1@forums-2-dub...
>> Hi,
>>
>> I am receiving this error on a Window Terminal Server 2003 running Citrix
>> MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526
>>
>>
>>
>> ODBC Error: Function :SQLFetch returned SQL_ERROR with state 08S01 native
>> error -85 RowCount=-2 NumResultCols=64 NumParams=0
>>
>> [Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link
>> failure:
>> Communication error
>>
>> Here is some more errror Info
>>
>> ODBC Information:
>> SQL Ver: SA70
>> Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE 7\WIN32\dbodbc7.dll
>> Description: SQL
>> EngineName: SQLSERVER
>> CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
>> DatabaseName: SQL70
>> AutoStop: Yes
>> Start:
>>
>> Any ideas would be helpfull.
>>
>> Thanks,
>> Roger
>>
>>
>
>


Robert Waywell Posted on 2005-01-19 17:35:05.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <41ed3755$1@forums-2-dub> <41ee7bd2$1@forums-2-dub> <41ee82aa$1@forums-2-dub>
Subject: Re: native error -85
Lines: 115
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <41ee9a49$1@forums-1-dub>
Date: 19 Jan 2005 09:35:05 -0800
X-Trace: forums-1-dub 1106156105 10.25.98.201 (19 Jan 2005 09:35:05 -0800)
X-Original-Trace: 19 Jan 2005 09:35:05 -0800, rwaywell-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4079
Article PK: 7965

The SQLCode -85 indicates an unexpected disconnect from the database server.
This is in contrast to other SQLCodes such as -101 which indicates that you
are not connected but that this is an expected state at the time. By
unexpected I mean that the client did not cleanly disconnect from the server
and did in fact expect to be connected at that point in time.

Generally speaking the SQLCode -85 is a symptom that the network was down
for some reason. In diagnosing this issue I would recommend starting with
the network layers to determine what, if any, issues are occuring there.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Roger" <Roger.J.Halbur@emcins.com> wrote in message
news:41ee82aa$1@forums-2-dub...
> Thanks, for the answer. I did how ever figure that part out. What I am
> looking for is a way to keep the application from loosing the connection.
> Is there some thing that can be added to the ODBC setting or the server or
> anything that will force it to keep connected? I am not the developer of
> the application that is loosing connection.
>
> Roger
>
>
>
> "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> news:41ee7bd2$1@forums-2-dub...
> > This error indicates that the application has lost the connection to the
> > database server.
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports:
> >
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> > iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> > news:41ed3755$1@forums-2-dub...
> >> Hi,
> >>
> >> I am receiving this error on a Window Terminal Server 2003 running
Citrix
> >> MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526
> >>
> >>
> >>
> >> ODBC Error: Function :SQLFetch returned SQL_ERROR with state 08S01
native
> >> error -85 RowCount=-2 NumResultCols=64 NumParams=0
> >>
> >> [Sybase][ODBC Driver][Adaptive Server Anywhere]Communication link
> >> failure:
> >> Communication error
> >>
> >> Here is some more errror Info
> >>
> >> ODBC Information:
> >> SQL Ver: SA70
> >> Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE 7\WIN32\dbodbc7.dll
> >> Description: SQL
> >> EngineName: SQLSERVER
> >> CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
> >> DatabaseName: SQL70
> >> AutoStop: Yes
> >> Start:
> >>
> >> Any ideas would be helpfull.
> >>
> >> Thanks,
> >> Roger
> >>
> >>
> >
> >
>
>


Bill Aumen Posted on 2005-01-26 03:19:11.0Z
Sender: 5a2d.41f70a88.1804289383@sybase.com
From: Bill Aumen
Newsgroups: ianywhere.public.general
Subject: Re: native error -85
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41f70c2b.5a3d.1681692777@sybase.com>
References: <41ee9a49$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 25 Jan 2005 19:19:07 -0800, 10.22.241.42
Lines: 135
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jan 2005 19:19:08 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jan 2005 19:19:11 -0800
X-Trace: forums-1-dub 1106709551 10.22.108.75 (25 Jan 2005 19:19:11 -0800)
X-Original-Trace: 25 Jan 2005 19:19:11 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4093
Article PK: 7976

This has been a hot topic on my agenda lately. One of my
network techs told me today that a DNS search by Windows
that results in a secondary DNS server being selected
results in a "reset" on all network connections on that
machine(to insure they get the new DNS address), thus
dropping my database connection.

That is one of quite a few reasons that database connections
are dropped when actually the LAN is doing it's thing
normally.

Bill

> The SQLCode -85 indicates an unexpected disconnect from
> the database server. This is in contrast to other SQLCodes
> such as -101 which indicates that you are not connected
> but that this is an expected state at the time. By
> unexpected I mean that the client did not cleanly
> disconnect from the server and did in fact expect to be
> connected at that point in time.
>
> Generally speaking the SQLCode -85 is a symptom that the
> network was down for some reason. In diagnosing this issue
> I would recommend starting with the network layers to
> determine what, if any, issues are occuring there.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer
>
> "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> news:41ee82aa$1@forums-2-dub...
> > Thanks, for the answer. I did how ever figure that part
> > out. What I am looking for is a way to keep the
> > application from loosing the connection. Is there some
> thing that can be added to the ODBC setting or the server
> > or anything that will force it to keep connected? I am
> > not the developer of the application that is loosing
> connection. >
> > Roger
> >
> >
> >
> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote
> > in message news:41ee7bd2$1@forums-2-dub...
> > > This error indicates that the application has lost the
> > > connection to the database server.
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to
> > all >
> > > To Submit Bug Reports:
> > >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
> > >
> > > SQL Anywhere Studio Supported Platforms and Support
> > > Status http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available
> > > through the iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> > > news:41ed3755$1@forums-2-dub...
> > >> Hi,
> > >>
> > >> I am receiving this error on a Window Terminal Server
> 2003 running Citrix
> > >> MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526
> > >>
> > >>
> > >>
> > >> ODBC Error: Function :SQLFetch returned SQL_ERROR
> with state 08S01 native
> > >> error -85 RowCount=-2 NumResultCols=64 NumParams=0
> > >>
> > >> [Sybase][ODBC Driver][Adaptive Server
> > Anywhere]Communication link >> failure:
> > >> Communication error
> > >>
> > >> Here is some more errror Info
> > >>
> > >> ODBC Information:
> > >> SQL Ver: SA70
> > >> Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE
> > 7\WIN32\dbodbc7.dll >> Description: SQL
> > >> EngineName: SQLSERVER
> > >> CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
> > >> DatabaseName: SQL70
> > >> AutoStop: Yes
> > >> Start:
> > >>
> > >> Any ideas would be helpfull.
> > >>
> > >> Thanks,
> > >> Roger
> > >>
> > >>
> > >
> > >
> >
> >
>
>


Bill Aumen Posted on 2005-01-26 03:25:04.0Z
Sender: 5a2d.41f70a88.1804289383@sybase.com
From: Bill Aumen
Newsgroups: ianywhere.public.general
Subject: Re: native error -85
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41f70d8e.5a52.1681692777@sybase.com>
References: <41ee9a49$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 25 Jan 2005 19:25:02 -0800, 10.22.241.42
Lines: 135
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jan 2005 19:25:03 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jan 2005 19:25:04 -0800
X-Trace: forums-1-dub 1106709904 10.22.108.75 (25 Jan 2005 19:25:04 -0800)
X-Original-Trace: 25 Jan 2005 19:25:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4094
Article PK: 7977


> Generally speaking the SQLCode -85 is a symptom that the
> network was down for some reason.

Not so says one of my network techs who told me today that a
DNS search by Windows that results in a secondary DNS server
being selected results in a "reset" on all network
connections on that machine(to insure they get the new DNS
address), thus dropping my database connections.

He says this is one a few reasons that database connections
are dropped when actually the LAN is doing it's thing
normally.

Bill
> The SQLCode -85 indicates an unexpected disconnect from
> the database server. This is in contrast to other SQLCodes
> such as -101 which indicates that you are not connected
> but that this is an expected state at the time. By
> unexpected I mean that the client did not cleanly
> disconnect from the server and did in fact expect to be
> connected at that point in time.
>
> Generally speaking the SQLCode -85 is a symptom that the
> network was down for some reason. In diagnosing this issue
> I would recommend starting with the network layers to
> determine what, if any, issues are occuring there.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer
>
> "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> news:41ee82aa$1@forums-2-dub...
> > Thanks, for the answer. I did how ever figure that part
> > out. What I am looking for is a way to keep the
> > application from loosing the connection. Is there some
> thing that can be added to the ODBC setting or the server
> > or anything that will force it to keep connected? I am
> > not the developer of the application that is loosing
> connection. >
> > Roger
> >
> >
> >
> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote
> > in message news:41ee7bd2$1@forums-2-dub...
> > > This error indicates that the application has lost the
> > > connection to the database server.
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to
> > all >
> > > To Submit Bug Reports:
> > >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
> > >
> > > SQL Anywhere Studio Supported Platforms and Support
> > > Status http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available
> > > through the iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> > > news:41ed3755$1@forums-2-dub...
> > >> Hi,
> > >>
> > >> I am receiving this error on a Window Terminal Server
> 2003 running Citrix
> > >> MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526
> > >>
> > >>
> > >>
> > >> ODBC Error: Function :SQLFetch returned SQL_ERROR
> with state 08S01 native
> > >> error -85 RowCount=-2 NumResultCols=64 NumParams=0
> > >>
> > >> [Sybase][ODBC Driver][Adaptive Server
> > Anywhere]Communication link >> failure:
> > >> Communication error
> > >>
> > >> Here is some more errror Info
> > >>
> > >> ODBC Information:
> > >> SQL Ver: SA70
> > >> Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE
> > 7\WIN32\dbodbc7.dll >> Description: SQL
> > >> EngineName: SQLSERVER
> > >> CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
> > >> DatabaseName: SQL70
> > >> AutoStop: Yes
> > >> Start:
> > >>
> > >> Any ideas would be helpfull.
> > >>
> > >> Thanks,
> > >> Roger
> > >>
> > >>
> > >
> > >
> >
> >
>
>


Greg Fenton Posted on 2005-01-26 03:44:26.0Z
From: Greg Fenton <greg.fenton_nospam_@ianywhere.com>
User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: native error -85
References: <41ee9a49$1@forums-1-dub> <41f70d8e.5a52.1681692777@sybase.com>
In-Reply-To: <41f70d8e.5a52.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <41f7121a$1@forums-1-dub>
Date: 25 Jan 2005 19:44:26 -0800
X-Trace: forums-1-dub 1106711066 69.198.107.137 (25 Jan 2005 19:44:26 -0800)
X-Original-Trace: 25 Jan 2005 19:44:26 -0800, cpec2cdc91b1d31-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 20
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4095
Article PK: 7979


Bill Aumen wrote:
>
> He says this is one a few reasons that database connections
> are dropped when actually the LAN is doing it's thing
> normally.
>

Replied to in the sybase.public.sqlanywhere.product_futures_discussion
newsgroup.

Let's continue the discussion there instead of here.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Bill Aumen Posted on 2005-01-26 03:18:20.0Z
Sender: 5a2d.41f70a88.1804289383@sybase.com
From: Bill Aumen
Newsgroups: ianywhere.public.general
Subject: Re: native error -85
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <41f70bf8.5a38.1681692777@sybase.com>
References: <41ee9a49$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 25 Jan 2005 19:18:16 -0800, 10.22.241.42
Lines: 135
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Jan 2005 19:18:17 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Jan 2005 19:18:20 -0800
X-Trace: forums-1-dub 1106709500 10.22.108.75 (25 Jan 2005 19:18:20 -0800)
X-Original-Trace: 25 Jan 2005 19:18:20 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4092
Article PK: 7978

This has been a hot topic on my agenda lately. One of my
network techs told me today that a DNS search by Windows
that results in a secondary DNS server being selected
results in a "reset" on all network connections on that
machine(to insure they get the new DNS address), thus
dropping my database connection.

That is one of quite a few reasons that database connections
are dropped when actually the LAN is doing it's thing
normally.

Bill

> The SQLCode -85 indicates an unexpected disconnect from
> the database server. This is in contrast to other SQLCodes
> such as -101 which indicates that you are not connected
> but that this is an expected state at the time. By
> unexpected I mean that the client did not cleanly
> disconnect from the server and did in fact expect to be
> connected at that point in time.
>
> Generally speaking the SQLCode -85 is a symptom that the
> network was down for some reason. In diagnosing this issue
> I would recommend starting with the network layers to
> determine what, if any, issues are occuring there.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available
> through the iAnywhere Developer Community at
> www.ianywhere.com/developer
>
> "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> news:41ee82aa$1@forums-2-dub...
> > Thanks, for the answer. I did how ever figure that part
> > out. What I am looking for is a way to keep the
> > application from loosing the connection. Is there some
> thing that can be added to the ODBC setting or the server
> > or anything that will force it to keep connected? I am
> > not the developer of the application that is loosing
> connection. >
> > Roger
> >
> >
> >
> > "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote
> > in message news:41ee7bd2$1@forums-2-dub...
> > > This error indicates that the application has lost the
> > > connection to the database server.
> > >
> > > --
> > > -----------------------------------------------
> > > Robert Waywell
> > > Sybase Adaptive Server Anywhere Developer - Version 8
> > > Sybase Certified Professional
> > >
> > > Sybase's iAnywhere Solutions
> > >
> > > Please respond ONLY to newsgroup
> > >
> > > EBF's and Patches: http://downloads.sybase.com
> > > choose SQL Anywhere Studio >> change 'time frame' to
> > all >
> > > To Submit Bug Reports:
> > >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
> > >
> > > SQL Anywhere Studio Supported Platforms and Support
> > > Status http://my.sybase.com/detail?id=1002288
> > >
> > > Whitepapers, TechDocs, and bug fixes are all available
> > > through the iAnywhere
> > > Developer Community at www.ianywhere.com/developer
> > >
> > > "Roger" <Roger.J.Halbur@emcins.com> wrote in message
> > > news:41ed3755$1@forums-2-dub...
> > >> Hi,
> > >>
> > >> I am receiving this error on a Window Terminal Server
> 2003 running Citrix
> > >> MetaFrame XP and Adaptive Server Anywhere 7.0.4.3526
> > >>
> > >>
> > >>
> > >> ODBC Error: Function :SQLFetch returned SQL_ERROR
> with state 08S01 native
> > >> error -85 RowCount=-2 NumResultCols=64 NumParams=0
> > >>
> > >> [Sybase][ODBC Driver][Adaptive Server
> > Anywhere]Communication link >> failure:
> > >> Communication error
> > >>
> > >> Here is some more errror Info
> > >>
> > >> ODBC Information:
> > >> SQL Ver: SA70
> > >> Driver: D:\PROGRAM FILES\SYBASE\SQL ANYWHERE
> > 7\WIN32\dbodbc7.dll >> Description: SQL
> > >> EngineName: SQLSERVER
> > >> CommLinks: TCPIP{host=(IPAddress):2638 -tl 0}
> > >> DatabaseName: SQL70
> > >> AutoStop: Yes
> > >> Start:
> > >>
> > >> Any ideas would be helpfull.
> > >>
> > >> Thanks,
> > >> Roger
> > >>
> > >>
> > >
> > >
> >
> >
>
>