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.

connection problem

4 posts in General Discussion Last posting was on 2004-10-04 18:54:06.0Z
march Posted on 2004-09-30 03:32:45.0Z
From: "march" <support@bbccable.com>
Newsgroups: ianywhere.public.general
Subject: connection problem
Lines: 15
MIME-Version: 1.0
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: 7bit
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: 210.177.103.253
X-Original-NNTP-Posting-Host: 210.177.103.253
Message-ID: <415b7e5d$1@forums-1-dub>
Date: 29 Sep 2004 20:32:45 -0700
X-Trace: forums-1-dub 1096515165 210.177.103.253 (29 Sep 2004 20:32:45 -0700)
X-Original-Trace: 29 Sep 2004 20:32:45 -0700, 210.177.103.253
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3650
Article PK: 7550

Hi, everybody.

We are use SQL Anywhere 5.505 build 2817.
Server use 2K and workstation use XP Pro SP1.
protool use IPX/SPX.

the problem is the client connect the sql server via ODBC,
client found the server to connect its about 15 second,
but use Win Me connect to server about 1 second both under same setting.
Hope anyone to help me how to solve the 15 second problem in XP Pro???

Thanks and Best Regards
March Cheung


Stephen Rice Posted on 2004-09-30 20:57:58.0Z
Newsgroups: ianywhere.public.general
Subject: Re: connection problem
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <415b7e5d$1@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns9574AC9CBB1C2sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: srice-pc1.sybase.com
X-Original-Trace: 30 Sep 2004 13:57:54 -0700, srice-pc1.sybase.com
Lines: 33
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 30 Sep 2004 13:57:55 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 30 Sep 2004 13:57:58 -0700
X-Trace: forums-1-dub 1096577878 10.22.108.75 (30 Sep 2004 13:57:58 -0700)
X-Original-Trace: 30 Sep 2004 13:57:58 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3660
Article PK: 7560


"march" <support@bbccable.com> wrote in news:415b7e5d$1@forums-1-dub:

> Hi, everybody.
>
> We are use SQL Anywhere 5.505 build 2817.
> Server use 2K and workstation use XP Pro SP1.
> protool use IPX/SPX.
>
> the problem is the client connect the sql server via ODBC,
> client found the server to connect its about 15 second,
> but use Win Me connect to server about 1 second both under same
> setting. Hope anyone to help me how to solve the 15 second problem in
> XP Pro???
>
> Thanks and Best Regards
> March Cheung
>
>
>

Turn on both client and server tracing to see where the delay is.

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

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


march Posted on 2004-10-04 02:37:19.0Z
From: "march" <support@bbccable.com>
Newsgroups: ianywhere.public.general
References: <415b7e5d$1@forums-1-dub> <Xns9574AC9CBB1C2sricenospamianywhere@10.22.241.106>
Subject: Re: connection problem
Lines: 46
MIME-Version: 1.0
Content-Type: text/plain; charset="big5"
Content-Transfer-Encoding: 8bit
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: 210.177.103.253
X-Original-NNTP-Posting-Host: 210.177.103.253
Message-ID: <4160b75f@forums-1-dub>
Date: 3 Oct 2004 19:37:19 -0700
X-Trace: forums-1-dub 1096857439 210.177.103.253 (3 Oct 2004 19:37:19 -0700)
X-Original-Trace: 3 Oct 2004 19:37:19 -0700, 210.177.103.253
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3685
Article PK: 7587

"Stephen Rice" <srice_nospam@ianywhere.com>
>>Turn on both client and server tracing to see where the delay is.

Sorry, I don't understand how to turn the client and server, can you give us
more details to me.
--

Thanks and Best Regards
March Cheung -

"Stephen Rice" <srice_nospam@ianywhere.com> 礎b繞l瞼籀
news:Xns9574AC9CBB1C2sricenospamianywhere@10.22.241.106 瞻瞻翹繞翹g...

> "march" <support@bbccable.com> wrote in news:415b7e5d$1@forums-1-dub:
>
> > Hi, everybody.
> >
> > We are use SQL Anywhere 5.505 build 2817.
> > Server use 2K and workstation use XP Pro SP1.
> > protool use IPX/SPX.
> >
> > the problem is the client connect the sql server via ODBC,
> > client found the server to connect its about 15 second,
> > but use Win Me connect to server about 1 second both under same
> > setting. Hope anyone to help me how to solve the 15 second problem in
> > XP Pro???
> >
> > Thanks and Best Regards
> > March Cheung
> >
> >
> >
>
> Turn on both client and server tracing to see where the delay is.
>
> /steve
>
> --
> Stephen Rice
> Technical Services Manager
> iAnywhere Solutions
>
> - Please Post-
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere Developer Community at www.ianywhere.com/developer
>


Stephen Rice Posted on 2004-10-04 18:54:06.0Z
Newsgroups: ianywhere.public.general
Subject: Re: connection problem
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <415b7e5d$1@forums-1-dub> <Xns9574AC9CBB1C2sricenospamianywhere@10.22.241.106> <4160b75f@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns95789793E1D99sricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: srice-pc1.sybase.com
X-Original-Trace: 4 Oct 2004 11:54:02 -0700, srice-pc1.sybase.com
Lines: 27
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 4 Oct 2004 11:54:03 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 4 Oct 2004 11:54:06 -0700
X-Trace: forums-1-dub 1096916046 10.22.108.75 (4 Oct 2004 11:54:06 -0700)
X-Original-Trace: 4 Oct 2004 11:54:06 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3689
Article PK: 7590


"march" <support@bbccable.com> wrote in news:4160b75f@forums-1-dub:

> "Stephen Rice" <srice_nospam@ianywhere.com>
>>>Turn on both client and server tracing to see where the delay is.
>
> Sorry, I don't understand how to turn the client and server, can you
> give us more details to me.

Server tracing is controlled through the -z commandline switch.

Client tracing can be done in two ways:
1) to get the details about the communications on the network use the
connection parameter LOG=
2) to see wether the delay is in the ODBC driver or your application
turn on ODBC tracing in the ODBC administrator.

/steve
--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

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