Error in "psqlodbca.dll"

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C7C4AA.D51906A0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_000B_01C7C4AA.D51906A0"


------=_NextPart_001_000B_01C7C4AA.D51906A0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable










Hello,

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' .

Could you help-me?

Thanks,
_________________________
Cl=E1udia Macedo Amorim
Consultora de Desenvolvimento
PC Sistemas - www.pcsist.com.br
(62) 3250-0200
claudia.amorim@pcinformatica.com.br

=20
Auto Servi=E7o WinThor: um novo conceito em tecnologia, seguran=E7a e =
agilidade.
------=_NextPart_001_000B_01C7C4AA.D51906A0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable



charset=3Dwindows-1252"> href=3D"file://C:\Arquivos de programas\Arquivos comuns\Microsoft =
Shared\Papel de carta\">



background=3Dcid:000901c7c4c3$fa63cda0$9fc8a8c0@pcserver.pci nformatica.co=
m.br>

Re: Error in "psqlodbca.dll"

On 12/07/2007 21:34, Cl=E1udia 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=20
> 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=20
help you, but you ought to post some more detail of the error before=20
anyone else can. For example, what version of Delphi? Are you using BDE=20
or any other interface? What *exactly* is the text of the error you get?=20
- and what are you doing when the error occurs?

Ray.

------------------------------------------------------------ ---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
------------------------------------------------------------ ---

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: 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=E1udia Macedo Amorim wrote:
>=20
> >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=20
> >application I receive an access violation in module *'psqlodbca.dll'* =
..
>=20
> Please don't send HTML email to the list.
>=20
> I don't really know enough about the internals of the ODBC driver to=20
> help you, but you ought to post some more detail of the error before=20
> anyone else can. For example, what version of Delphi? Are you using BDE=
=20
> or any other interface? What *exactly* is the text of the error you get=
?=20
> - 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

Re: Error in "psqlodbca.dll"

Hi,
I'm using the 8.01.02.00 version of psqlodbca.dll, Delphi 2006 and I=20
access the PostGreSQL through ADO components.
The error occurs when I try to execute the sql statement: "select * from=20
fact".
The error message is:
"Project BI.exe raised exception class EAccessViolation with message 'Acc=
ess=20
violation at adress 027B9D26 in module 'psqlodbca.dll". Write of address=20
00000000."

Thanks,
Cl=E1udia.

----- Original Message -----=20
From: "Ludek Finstrle"
To: "Raymond O'Donnell"
Cc: "Cl=E1udia Macedo Amorim" ;=20

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=E1udia 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 BD=
E
>> or any other interface? What *exactly* is the text of the error you ge=
t?
>> - 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
>=20


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Error in "psqlodbca.dll"

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 'Acc=
ess
violation at adress 027B9D26 in module 'psqlodbca.dll". Write of address
00000000."

Thanks,
Cl=E1udia.

----- Original Message -----=20
From: "Ludek Finstrle"
To: "Raymond O'Donnell"
Cc: "Cl=E1udia Macedo Amorim" ;=20

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=E1udia 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 BD=
E
>> or any other interface? What *exactly* is the text of the error you ge=
t?
>> - 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
>=20


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Error in "psqlodbca.dll"

Do other queries work, and only this one gives the error? What happens=20
if you did a query with a where conition that returned only 10 rows,=20
would you still get the error? Also I'm not much of a Delphi programmer,=20
but I have an idea of what ADO code should look like, could you post the=20
code snipit in question?


Cl=E1udia 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 * fro=
m
> fact".
> The error message is:
> "Project BI.exe raised exception class EAccessViolation with message=20
> 'Access
> violation at adress 027B9D26 in module 'psqlodbca.dll". Write of addres=
s
> 00000000."
>=20
> Thanks,
> Cl=E1udia.
>=20
> ----- Original Message ----- From: "Ludek Finstrle"
> To: "Raymond O'Donnell"
> Cc: "Cl=E1udia Macedo Amorim" ;=20
>
> Sent: Friday, July 13, 2007 7:07 AM
> Subject: Re: [ODBC] Error in 'psqlodbca.dll'
>=20
>=20
>> Thu, Jul 12, 2007 at 11:04:36PM +0100, Raymond O'Donnell napsal(a):
>>> On 12/07/2007 21:34, Cl=E1udia 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 B=
DE
>>> or any other interface? What *exactly* is the text of the error you g=
et?
>>> - 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
>>
>=20
>=20
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 4: Have you searched our list archives?
>=20
> http://archives.postgresql.org


--=20
David Gardner

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Error in "psqlodbca.dll"

Hello,

> 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?

David the psqlodbc 08.01.0200 is dead branch. It's based on libpq.

> >I'm using the 8.01.02.00 version of psqlodbca.dll, Delphi 2006 and I

Please let's try latest psqlodbc version at first. 08.01 version has
no support at all. Don't worry about pgsql version. The 08.02 psqlodbc
driver supports pgsql 7.X and 8.X pgsql at least.

Regards,

Luf

P.S. psqlodbc 08.01 has several broken features so let's try play (disable)
with connection settings (e.g. disallow premature, updateable cursor
etc)

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate