pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC bind trouble with bigint
3+ messages / 2 participants
[nested] [flat]
* ODBC bind trouble with bigint
@ 2000-02-01 18:06 Ken J. Wright <ken@ori-ind.com>
0 siblings, 1 reply; 3+ messages in thread
From: Ken J. Wright @ 2000-02-01 18:06 UTC (permalink / raw)
To: pgsql-interfaces; +Cc: Byron Nikolaidis <byron.nikolaidis@home.com>
With Delphi 4/ODBCExpress 5.04 and psqlodbc 6.40.0008, this error occurs
when opening a dataset that includes an int8 column.
Project1 ee:dc ENTER SQLBindCol
HSTMT 0x010b2138
UWORD 3
SWORD -25 <SQL_C_SBIGINT>
PTR 0x011b7574
SDWORD 0
SDWORD * 0x011b75ac
Project1 ee:dc EXIT SQLBindCol with return code -1 (SQL_ERROR)
HSTMT 0x010b2138
UWORD 3
SWORD -25 <SQL_C_SBIGINT>
PTR 0x011b7574
SDWORD 0
SDWORD * 0x011b75ac
DIAG [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support
this parameter (0)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC bind trouble with bigint
@ 2000-02-02 01:39 Byron Nikolaidis <byron.nikolaidis@home.com>
parent: Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 2000-02-02 01:39 UTC (permalink / raw)
To: Ken J. Wright <ken@ori-ind.com>; +Cc: pgsql-interfaces
"Ken J. Wright" wrote:
>
> With Delphi 4/ODBCExpress 5.04 and psqlodbc 6.40.0008, this error occurs
> when opening a dataset that includes an int8 column.
>
> Project1 ee:dc ENTER SQLBindCol
> HSTMT 0x010b2138
> UWORD 3
> SWORD -25 <SQL_C_SBIGINT>
> PTR 0x011b7574
> SDWORD 0
> SDWORD * 0x011b75ac
>
> Project1 ee:dc EXIT SQLBindCol with return code -1 (SQL_ERROR)
> HSTMT 0x010b2138
> UWORD 3
> SWORD -25 <SQL_C_SBIGINT>
> PTR 0x011b7574
> SDWORD 0
> SDWORD * 0x011b75ac
>
> DIAG [HYC00] [Microsoft][ODBC Driver Manager] Driver does not support
> this parameter (0)
>
> ************
I'm thinking this has to be an odbc 3.0 compatibility problem. The
default for odbc 2.x is that BIGINT uses a SQL_C data type of
SQL_C_CHAR. I tested BindCol and it worked fine. There is no
SQL_C_SBIGINT in odbc 2.x. Seems to me the odbc 3.0 driver manager
should bridge the gap and use an SQL_C_CHAR for the driver side.
So, I don't know what to tell you. I imagine you don't have any control
over the SQL_C_ data type, right?
Byron
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC bind trouble with bigint
@ 2000-02-02 05:48 Ken J. Wright <ken@ori-ind.com>
0 siblings, 0 replies; 3+ messages in thread
From: Ken J. Wright @ 2000-02-02 05:48 UTC (permalink / raw)
To: Byron Nikolaidis <byron.nikolaidis@home.com>; +Cc: pgsql-interfaces
At 20:39 02/01/2000 -0500, Byron Nikolaidis wrote:
>
>
>"Ken J. Wright" wrote:
>>
>> With Delphi 4/ODBCExpress 5.04 and psqlodbc 6.40.0008, this error occurs
>> when opening a dataset that includes an int8 column.
>>
>> Project1 ee:dc ENTER SQLBindCol
>> HSTMT 0x010b2138
>> UWORD 3
>> SWORD -25 <SQL_C_SBIGINT>
>> PTR 0x011b7574
>> SDWORD 0
>> SDWORD * 0x011b75ac
>>
>> Project1 ee:dc EXIT SQLBindCol with return code -1 (SQL_ERROR)
>> HSTMT 0x010b2138
>> UWORD 3
>> SWORD -25 <SQL_C_SBIGINT>
>> PTR 0x011b7574
>> SDWORD 0
>> SDWORD * 0x011b75ac
>>
>> DIAG [HYC00] [Microsoft][ODBC Driver Manager] Driver
does not support
>> this parameter (0)
>>
>> ************
>
>
>I'm thinking this has to be an odbc 3.0 compatibility problem. The
>default for odbc 2.x is that BIGINT uses a SQL_C data type of
>SQL_C_CHAR. I tested BindCol and it worked fine. There is no
>SQL_C_SBIGINT in odbc 2.x. Seems to me the odbc 3.0 driver manager
>should bridge the gap and use an SQL_C_CHAR for the driver side.
The bridge does seem to fall short occasionally ;-(
>So, I don't know what to tell you. I imagine you don't have any control
>over the SQL_C_ data type, right?
I copied this message to the ODBCExpress people as well. It's all part of
the code that's wrapped around opening a dataset. The API can certainly be
hacked, but I'll wait until I here something back. It takes a couple/few
days, but they usually have a good reply.
Ken
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-02-02 05:48 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-01 18:06 ODBC bind trouble with bigint Ken J. Wright <ken@ori-ind.com>
2000-02-02 01:39 ` Byron Nikolaidis <byron.nikolaidis@home.com>
2000-02-02 05:48 Re: [INTERFACES] ODBC bind trouble with bigint Ken J. Wright <ken@ori-ind.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox