DOCUMENT:Q184806 11-SEP-2001 [odbc] TITLE :FIX: SQLPutData Truncates LONG RAW Data Using Oracle ODBC Driver PRODUCT :Open Database Connectivity (ODBC) PROD/VER::Build 2.73.7269,Build 2.73.7283.01,Build 2.73.7283.03 OPER/SYS: KEYWORDS:kbDriver kbODBC kbOracle kbODBC200bug kbODBC200fix kbGrpDSMDAC kbGrpDSODBC kbMDACNoSwee ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft ODBC for Oracle version 2.0, versions Build 2.73.7269, Build 2.73.7283.01, Build 2.73.7283.03 ------------------------------------------------------------------------------- SYMPTOMS ======== Using the Microsoft ODBC Driver for Oracle (build 2.73.728303) that ships with MDAC 1.5c causes a SQL_SUCCESS_WITH_INFO message and a "Data Truncated" error when trying to store LONG RAW data with SQLPutData and using SQLBindParameter with the ColumnSize (6th Parameter) set to 0 or less than the actual length of the data. This occurs even though SQLGetInfo for SQL_NEED_LONG_DATA_LEN returns a "No". Also, no data is written to the LONG RAW field. The problem occurs if you bind the parameter as a SQL_C_BINARY and SQL_BINARY like this: g_rc = SQLBindParameter(g_hstmt, 1, SQL_PARAM_INPUT, SQL_C_BINARY, SQL_BINARY, 0, 0, NULL, 0, &cbVal1); RESOLUTION ========== Make the Columnsize parameter of the SQLBindParameter equal to or greater than the actual value of the data length passed in SQLPutData. Upgrade to the Microsoft Oracle ODBC Driver available in Visual Studio 6.0 or Microsoft Data Access Components version 2.0 or later. You can download the MDAC Components from the following Web address: http://www.microsoft.com/data/ STATUS ====== This bug has been fixed in version 2.573.2927 of the Microsoft Oracle ODBC Driver. Additional query words: msoracle ====================================================================== Keywords : kbDriver kbODBC kbOracle kbODBC200bug kbODBC200fix kbGrpDSMDAC kbGrpDSODBC kbMDACNoSweep Technology : kbAudDeveloper kbODBCSearch kbODBCOracle2737269 kbODBCOracle273728303 kbODBCOracle273728301 kbODBCOracle200Search Version : :Build 2.73.7269,Build 2.73.7283.01,Build 2.73.7283.03 Issue type : kbbug Solution Type : kbfix ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2001.