Subject: | |
From: | |
Reply To: | |
Date: | Wed, 11 Nov 1998 09:44:44 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
> Wayne Laughton writes:
>
> >Since the upgrade on the weekend, our users have been complaining of
> >being locked out of the database (the 3000 app tells users that
> >Database is busy) consistantly. Apart from the upgrade to
> 5.5, nothing else has changed.
Are these host-based apps, client-server apps using ODBC or a combination of
both?
Basically, nothing should have changed (we run 5.5 PP5 here on one machine).
Your DBLOCK calls should operate in the same fashion, and for ODBC apps,
ensure that you are using RU as your isolation level. Image/SQL recognizes
two isolation levels basically (although Allbase provides for four) - these
are RU (Read Uncommitted) and RR (Repeatable Read). "RR" will yield the
symptoms shown above, so check any possible ODBC apps (or third-party apps
which use ODBC such as Crystal Reports, Impromptu, etc) for the proper
isolation level. This can be checked by examining the setup in the ODBC
Administrator in the Control Panel.
Feel free to e-mail me privately with more details should this not do the
trick.
Best Regards,
Joe
==========================================================
Joe Geiser, Senior Partner, CSI Business Solutions, LLC
** Your Client-Server and Internetworking Specialists **
Phone: +1 (215) 945.8100 Fax: +1 (215) 943.8408
*New* Toll-Free (US/Canada): (877) 945-8100
http://www.csillc.com
==========================================================
HP Channel Partner Allaire Alliance Partner
Microsoft ClubWin - Team One
|
|
|