Re: [INTERFACES] Odbc driver

From: Sergio <ser(at)perio(dot)unlp(dot)edu(dot)ar>
To: pgsql-interfaces(at)hub(dot)org
Subject: Re: [INTERFACES] Odbc driver
Date: 1999-03-30 22:22:26
Message-ID: SAK.1999.03.30.inqphpkb@speedy.perio.unlp.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Sergio <ser(at)perio(dot)unlp(dot)edu(dot)ar> el día Tue, 30 Mar 1999 12:40:10 -0300,
escribió:

>
>Byron,
>
>Postgres 6.3.2, Odbc driver 6.40.0004
>
>
>I get this
>
>'Access violation at address xxxxxxx in module 'PSQLODBC.DLL'.
>Read of address yyyyyyyy'
>
>calling SQLGetData( hstmt, FieldNo, SQL_BINARY, SQLPOINTER( @i), 0, @iv);
>
>note the 5th parameter -> 0
>
>over a TEXT field with sizes of 4000 or more bytes.
>
>if I try it with small fields (3000 or so bytes) there is no problem.
>
>ok, I tracked it down and it seems to work until iv=4099,
>when it must return 4100, boom !

I _think_ I found the problem:

in convert.c in the function copy_and_convert_field, you declare

char tempBuf[TEXT_FIELD_SIZE+5];

wich is fixed at _compile_ time, no ?, so the TEXT_FIELD_SIZE wich
is an option in the Odbc driver cfg, is ignored.

I'm rigth ? (because changing Max LongVarChar in the cfg doesn't
seems to affect nothing)

Sergio

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sergio 1999-03-30 22:26:02 Re: [INTERFACES] Newbie w/ ODBC client not working!!
Previous Message Mark 1999-03-30 21:25:40 Newbie w/ ODBC client not working!!