Thread: BUG #3600: ODBC Driver not working with BIGINT

BUG #3600: ODBC Driver not working with BIGINT

From
"Phillip Carruthers"
Date:
The following bug has been logged online:

Bug reference:      3600
Logged by:          Phillip Carruthers
Email address:      pjc@seemoretechnologies.com
PostgreSQL version: 7.4.16
Operating system:   Redhat 4
Description:        ODBC Driver not working with BIGINT
Details:

When using SQLBindParameter with type BIGINT I get the following error;

Unable to execute statement due to [unixODBC]Unrecognized C_parameter type
in copy_statement_with_parameters; Unrecognized key passed to SQLGetInfo

I get the same error on Redhat 5 with Postgres 8.1

I do NOT get the error using Postres 8.2.4 on Windows.

It seems that only the Windows ODBC driver is work for BIGINT.

Re: BUG #3600: ODBC Driver not working with BIGINT

From
"Hiroshi Saito"
Date:
Hi.

Umm, I have not reproduced a problem...
Would you be shown the reproducible code?
and what Version of psqlODBC.?

Regards,
Hiroshi Saito

From: "Phillip Carruthers" <pjc@seemoretechnologies.com>


>
> The following bug has been logged online:
>
> Bug reference:      3600
> Logged by:          Phillip Carruthers
> Email address:      pjc@seemoretechnologies.com
> PostgreSQL version: 7.4.16
> Operating system:   Redhat 4
> Description:        ODBC Driver not working with BIGINT
> Details:
>
> When using SQLBindParameter with type BIGINT I get the following error;
>
> Unable to execute statement due to [unixODBC]Unrecognized C_parameter type
> in copy_statement_with_parameters; Unrecognized key passed to SQLGetInfo
>
> I get the same error on Redhat 5 with Postgres 8.1
>
> I do NOT get the error using Postres 8.2.4 on Windows.
>
> It seems that only the Windows ODBC driver is work for BIGINT.

Re: BUG #3600: ODBC Driver not working with BIGINT

From
"Hiroshi Saito"
Date:
Hi.

----- Original Message -----
From: "Phillip Carruthers" <pjc@seemoretechnologies.com>


> *This message was transferred with a trial version of CommuniGate(r) Pro*
>
> Hi Hiroshi,
> I removed the version I had and installed Postgres 8.2.4 on Redhat 4
> I also download the latest source for ODBC and built it.
>
> I still got the issue with BIGINT using libodbcpsql.so.
> Then I noticed psqlodbcw.so and tried that library.
>
> I can now use BIGINT so I am happy.

:-)

>
> I do not know the difference between /usr/local/lib/libodbcpsql.so and
> /usr/local/lib/psqlodbcw.so

I think libodbcpsql.so is this....
http://unixodbc.cvs.sourceforge.net/unixodbc/unixODBC/Drivers/PostgreSQL/psqlodbc.h?annotate=1.4

Anyway, Thank you as a good result of using.!

Regards,
Hiroshi Saito