Replying to my own message...
Kelly Burkhart wrote:
> I am having a problem in running some code in 64 bit unix. I'm running
> unixODBC and psqlodbc-08.00.0005 on SuSE 9.1 x86-64.
> If I bind a 32 bit integer using SQL_INTEGER/SQL_C_LONG and pass a value
> of -1, the insert fails with an 'integer out of range' error. The
> reason this happens is the sprintf near line 2658 of convert.c.
> case SQL_C_SLONG:
> case SQL_C_LONG:
> sprintf(param_string, "%ld",
> *((SDWORD *) buffer));
It appears that SQL_C_LONG does correspond to a 32-bit integer and not
the native long.
I'm attaching a patch which fixes this, and some other questionable
sprintf format strings in convert.c.
In response to
pgsql-odbc by date
|Next:||From: jross||Date: 2005-03-04 23:42:30|
|Subject: Installation problem with psqlodbc-08_00_0100.zip|
|Previous:||From: Theodore Petrosky||Date: 2005-03-03 12:50:00|
|Subject: odbc on Mac OS X|