Oracle-L: Re: VB and Oracle...memory limiting the amount of records returned?

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Fri, 14 Jun 2002 18:03:20 -0800
Message-ID: <F001.0047EB3A.20020614180320@fatcity.com>

We have a similar problem with a vendor supplied application. We solved it
(at least we masked the symptom) by increasing the ODBC timeout in the
user's W2K registry.

The vendor app uses an ODBC connect to a CORBA broker (OpenLink) on the server. It's a bank rec that was only returning a portion of the payroll checks issued.

David A. Barbour
AISD

                                                                                                                   
                    "Grabowy,                                                                                      
                    Chris"               To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <cgrabowy_at_fcg.       cc:                                                                       
                    com>                 Subject:     VB and Oracle...memory limiting the amount of records        
                    Sent by:              returned?                                                                
                    root_at_fatcity.c                                                                                 
                    om                                                                                             
                                                                                                                   
                                                                                                                   
                    06/14/2002                                                                                     
                    03:43 PM                                                                                       
                    Please respond                                                                                 
                    to ORACLE-L

We have a VB app that uses Oracle as the database. The users noticed a limitation in the amount of records being returned from the database. So they decided to increase the memory of the PC and some additional volume of records were returned. ??

Has anyone using VB/Oracle noticed this?? Is this simply a sign of bad coding? Trying to load up all the records into memory, and therefore failing?

Any clues, references or links would be appreciated.

TIA!!!!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grabowy, Chris
  INET: cgrabowy_at_fcg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: DBarbour_at_austin.isd.tenet.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Fri Jun 14 2002 - 21:03:20 CDT