Do other queries work, and only this one gives the error? What happens
if you did a query with a where conition that returned only 10 rows,
would you still get the error? Also I'm not much of a Delphi programmer,
but I have an idea of what ADO code should look like, could you post the
code snipit in question?
Cláudia Macedo Amorim wrote:
> Hi,
> I'm using the 8.01.02.00 version of psqlodbca.dll, Delphi 2006 and I
> access the PostGreSQL through ADO components.
> The error occurs when I try to execute the sql statement: "select * from
> fact".
> The error message is:
> "Project BI.exe raised exception class EAccessViolation with message
> 'Access
> violation at adress 027B9D26 in module 'psqlodbca.dll". Write of address
> 00000000."
>
> Thanks,
> Cláudia.
>
> ----- Original Message ----- From: "Ludek Finstrle" <luf@pzkagis.cz>
> To: "Raymond O'Donnell" <rod@iol.ie>
> Cc: "Cláudia Macedo Amorim" <claudia.amorim@pcinformatica.com.br>;
> <pgsql-odbc@postgresql.org>
> Sent: Friday, July 13, 2007 7:07 AM
> Subject: Re: [ODBC] Error in 'psqlodbca.dll'
>
>
>> Thu, Jul 12, 2007 at 11:04:36PM +0100, Raymond O'Donnell napsal(a):
>>> On 12/07/2007 21:34, Cláudia Macedo Amorim wrote:
>>>
>>> >I'm having a problem when I try to retrieve records.
>>> >I'm using PostgreSQL 8.1 and a Delphi application.
>>> >When I try tro retrieve more than 300.000 records through Delphi
>>> >application I receive an access violation in module *'psqlodbca.dll'* .
>>>
>>> Please don't send HTML email to the list.
>>>
>>> I don't really know enough about the internals of the ODBC driver to
>>> help you, but you ought to post some more detail of the error before
>>> anyone else can. For example, what version of Delphi? Are you using BDE
>>> or any other interface? What *exactly* is the text of the error you get?
>>> - and what are you doing when the error occurs?
>>
>> + what version of psqlodbc are you using?
>>
>> Luf
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
--
David Gardner
