| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| There seems to be a bug in the new SQL2008 ODBC driver where if you call SQLBindCol on a numeric column binding as SQL_C_DOUBLE the fetch call fails with an error: "[Microsoft][SQL Server Native Client 10.0]Numeric value out of range" If the BufferLength parameter is 0 the fetch fails. When BufferLength is set to 8 (size of a double) the fetch succeeds. According to the MS documentation BufferLength should be ignored for fixed length data. From the MS ODBC documentation: "When the driver returns fixed-length data, such as an integer or a date structure, the driver ignores BufferLength and assumes the buffer is large enough to hold the data. It is therefore important for the application to allocate a large enough buffer for fixed-length data or the driver will write past the end of the buffer. " |
![]() |
| Thread Tools | |
| Display Modes | |