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.

SUDDEN SLOW ODBC

2 posts in Windows NT Last posting was on 1997-10-22 17:56:20.0Z
Craig Davis Posted on 1997-10-22 17:42:31.0Z
From: "Craig Davis" <craigd@panamax.com>
Subject: SUDDEN SLOW ODBC
Organization: Panamax
Message-ID: <01bcdf1a$d15b5a20$3272a826@craigd>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Wed, 22 Oct 1997 13:42:31 -0400
Lines: 42
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5467
Article PK: 1081545

Have a problem that is appearing very suddenly and it appears to be
something with ODBC.

Have a VB5 app that uses ODBC connection to Sybase 11.0.2.2 on WinNT 4.0 SP
1.
Clients are Win95. Problem has happened with ODBC 2 and 3 drivers.

A workstation is working fine getting data back from Sybase. User then
reports slow down on getting responses from Syabse. Search that took 2
seconds now takes 2 minutes.

Once a computer experiences this slowdown, it affects whoever is logged in
at this computer. We save win95 profiles on NT. If user then logs into
another machine, that machine becomes slow as well.

I have uninstalled and reinstalled ODBC drivers, Sybase open client files,
VB app and tested speed after each reload. No Luck. Talked with Sybase
support. The suggested installing current EBFs. did that for ODBC and
open client. NO LUCK.

I'm down to wiping out user's profiles and formating and reloading the
machines.

Checked for viruses. Rebooted all servers. Ran chkdsk on all servers. 2
machines side by side and 1 will run fine while the other is VERY slow.
Tried using ACCESS to connect to Sybase server and experienced slow
connections on slow mahcines and fast connections on fast machines. Slow
machines run everything else at normal speed. Run Access against and
Access mdb file on the sybase server and that runs fine.

Appears that a Registery setting is getting screwed up, but can not find
anything obvious.

Reading this I would think the person writing it was crazy, but having
experienced it I don't think I'm crazy?

Any ideas or suggestions? Has anyone seen anything like this?


Craig Davis Posted on 1997-10-22 17:56:20.0Z
From: "Craig Davis" <craigd@panamax.com>
Subject: Re: SUDDEN SLOW ODBC
References: <01bcdf1a$d15b5a20$3272a826@craigd>
Organization: Panamax
Message-ID: <01bcdf1c$bfbc5380$3272a826@craigd>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Wed, 22 Oct 1997 13:56:20 -0400
Lines: 55
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5465
Article PK: 1081544

Problem Solved! Thanks to Larry Stavinoha that directed us to a Microsoft
Knowledge Base article Q152453. Need to add a registery setting.

<HKey_Local_Machine>
System\CurrentControlSet\Services\Vxd\VNETSUP
From edit menu select new - string value
Name=DirectHost
Value=0
Reboot and all is back to normal

Thank you Larry

Craig Davis <craigd@panamax.com> wrote in article
<01bcdf1a$d15b5a20$3272a826@craigd>...
> Have a problem that is appearing very suddenly and it appears to be
> something with ODBC.
>
> Have a VB5 app that uses ODBC connection to Sybase 11.0.2.2 on WinNT 4.0
SP
> 1.
> Clients are Win95. Problem has happened with ODBC 2 and 3 drivers.
>
> A workstation is working fine getting data back from Sybase. User then
> reports slow down on getting responses from Syabse. Search that took 2
> seconds now takes 2 minutes.
>
> Once a computer experiences this slowdown, it affects whoever is logged
in
> at this computer. We save win95 profiles on NT. If user then logs into
> another machine, that machine becomes slow as well.
>
> I have uninstalled and reinstalled ODBC drivers, Sybase open client
files,
> VB app and tested speed after each reload. No Luck. Talked with Sybase
> support. The suggested installing current EBFs. did that for ODBC and
> open client. NO LUCK.
>
> I'm down to wiping out user's profiles and formating and reloading the
> machines.
>
> Checked for viruses. Rebooted all servers. Ran chkdsk on all servers.
2
> machines side by side and 1 will run fine while the other is VERY slow.
> Tried using ACCESS to connect to Sybase server and experienced slow
> connections on slow mahcines and fast connections on fast machines. Slow
> machines run everything else at normal speed. Run Access against and
> Access mdb file on the sybase server and that runs fine.
>
> Appears that a Registery setting is getting screwed up, but can not find
> anything obvious.
>
> Reading this I would think the person writing it was crazy, but having
> experienced it I don't think I'm crazy?
>
> Any ideas or suggestions? Has anyone seen anything like this?
>