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

Re: 64 bit integers

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Christian Bucanac <christian(dot)bucanac(at)mindark(dot)com>
Cc: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: 64 bit integers
Date: 2001-04-19 02:16:31
Message-ID: 3ADE4A7F.D9A72C78@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Christian Bucanac wrote:
> 
> Hi!
> 
> I posted earlier a question about int8 and ODBC, see below. I got the answer
> that int8 works with ODBC driver version 07.01.0001 and later. The problem
> is that I can not make it work. I use postgres version 6.4 with ODBC driver
> version 07.01.00.04. Everyting works fine, but not with int8. When I try to
> bind an int8 with:
> 
> SQLHSTMT lStatementHandle;
> SQLINTEGER lMetadata;
> SQLBIGINT lInt64;
> SQLBindCol(lStatementHandle, 1, SQL_C_SBIGINT, &lInt64, sizeof(lInt64),
> &lMetadata);
> 
> SQLBindCol returns SQL_ERROR and when I run SQLGetDiagRec on the statement
> handle I get the following information:
> SQLState: S1003 (meaning Invalid application buffer type)

It seems that version 3.0 or later is required to handle
SQL_C_SBIGINT. Unfortunately psqlodbc's driver version is
2.5.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Keith ToddDate: 2001-04-19 04:36:59
Subject: include files
Previous:From: Braxton BeyerDate: 2001-04-18 16:25:57
Subject: DB grid

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