Skip site navigation (1) Skip section navigation (2)

Re: Error in 'psqlodbca.dll'

From: David Gardner <david(at)gardnerit(dot)net>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error in 'psqlodbca.dll'
Date: 2007-07-14 14:06:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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 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(at)pzkagis(dot)cz>
> To: "Raymond O'Donnell" <rod(at)iol(dot)ie>
> Cc: "Cláudia Macedo Amorim" <claudia(dot)amorim(at)pcinformatica(dot)com(dot)br>; 
> <pgsql-odbc(at)postgresql(dot)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?
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?

David Gardner

In response to


pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2007-07-16 09:50:28
Subject: Re: Error in 'psqlodbca.dll'
Previous:From: Cláudia Macedo AmorimDate: 2007-07-13 19:43:53
Subject: Error in 'psqlodbca.dll'

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group