Re: Non-blocking Oracle client applications under Windows3.1/95

In article <31eaea33.4730950_at_news.compuserve.com>, 74010.2100_at_compuserve.com says...
>
>I'm currently using SQL-Net 2.x on my Win 95 PC running various Oracle
>client applications, all of which seem to suspend my machine when the
>Oracle server is "thinking about" a query before sending results back.
>This happens when I run Oracle's own SQL-Plus and many Borland Delphi
>tools running against SQL-Net.
>
>Is it normal for Oracle/SQL-Net to block all Windows messsages while
>it is working on something? Does this vary from one version of
>SQL-Net to another? Is there any way to tweek some Oracle
>configuration files to overcome this problem?
>
>Any ideas or insights would be appreciated.
>
>Thanks,
>-Ken Borsare
>Ken Borsare
>74010.2100_at_Compuserve.com

We encountered long connect delays when we moved from win3.1, sql*net 1 to win 95 and sql*net 2. We are using 16 bit third party windows software on the client machines which uses sql*net.
We found that these delays happen when win 95 and sql*net 2 are combined. We are back with sql*net 1 for now

Page 7 of the release notes for Oracle7 workgroup server 7.2.2.4.6 has the following item:"When using Novell's Client 32 for windows and connecting to a Netware server with 16 bit Oracle SPX Protocol Adapter for Windows, the second server connection can take some time"

We encountered delays while using our software because it was apparently making connections and then breaking them as various client functions were performed.

Possibly related to your problem?

Disclaimer: this is a personal view only.

-- 
allan marshall       marshall.allan.ar_at_bhp.com.au
senior condition monitoring engineer
BHP New Zealand Steel Ltd, private bag 92121, Auckland, New Zealand
tel:   +64 9 3758 111 x 7366