Re: VB6 SP3 / ADO2.1 /Ora 8 - "Error - Memory could not be written"

From: Bill Honey <bill_at_honeyb.demon.co.uk>
Date: Thu, 12 Aug 1999 17:34:41 GMT
Message-ID: <37b70566.262016680_at_news.demon.co.uk>


[Quoted] Are you setting a filter by any chance ?

I'm getting the same problem with SQL server 7.0 when I set a filter. Looks like a memory leak in ADO somewhere. How to find though ...

"jason" <jfielding_at_trinitech.co.uk> wrote:

>OK - call me dumb, but can you tell me how I find this out.
>If it's any help, I use a DSN in my Connect String which references an MS
>ODBC for Oracle driver (2.573.4202.00).
>
>
>Mike Sprague wrote in message ...
>>Jason,
>>
>>Are you using the ODBC OLEDB provider or the Oracle OLEDB provider?
>>
>>We are using the Oracle provider and not having any problems with using SP
>>in packages to do our inserts, etc.
>>
>>Env:
>>VB6SP3
>>Oracle8.0.5 on HPUX
>>ADO 2.10.3711.9 - Could be issue here
>>SQL Net 2.3
>>
>>Mike
>>
>>jason wrote in message <7op0t2$88b$1_at_trinitech.demon.co.uk>...
>>>I'm trying to insert records (using VB6 SP3 and ADO 2.10.4202.1) via a
>>>Stored Function into an Oracle 8.0.4 DB. The Fn is supposed to inserts a
>>new
>>>record and passes back the new Oracle - generated PK. If I try passing
>more
>>>than 5 parameters to the Fn - VB blows with - "at 0xXXXXXXXX referenced
>>>memory at 0xXXXXXXXX. The
>>>memory could not be written. " This is followed by the error - "at
>>>0xXXXXXXXX referenced memory at 0xXXXXXXXX. The memory could not be read.
>>"
>>>Which kills my App and VB.
>>>The action runs successfully if I limit the number of parameters to 5 but
>>>this no good to me. My largest Fn is only 13 parameters, surely ADO can
>>cope
>>>with more than 5 by now ?? .Is there another method of doing this or a
>>>Command Property I can set ?
>>>I've also tried this using an Stored Proc within a Package - same thing !!
>>>Please Help !!
>>>
>>>Any suggesetions are much appreciated.
>>>Thanks
>>>Jason
>>>
>>>
>>>
>>>
>>>
>>
>>
>


[Quoted]  Dr. Bill Honey        
 Collage Consulting Ltd.                     
Received on Thu Aug 12 1999 - 19:34:41 CEST

Original text of this message