Feedback
Did this article resolve your question/issue?

   

Article

Reading data using DataDirect SQL Server ODBC driver is too slow compared to OLEDB driver

Information

 
TitleReading data using DataDirect SQL Server ODBC driver is too slow compared to OLEDB driver
URL Namereading-data-from-sql-server-using-datadirect-driver-is-too-slow-compared-to-the-oledb-driver
Article Number000133325
EnvironmentProduct: Connect 64 for ODBC SQL Server driver
Version: 07.16.0345
OS: Windows
Database: SQL Server
Application: All supported applications
Question/Problem Description
Reading hundred thousands records from SQL Server database using DataDirect SQL Server ODBC driver took 22 seconds where as reading the same using Microsoft OLEDB driver took 1 second.
Trace logs from the datadirect ODBC SQL Server driver shows hundreds of thousands of the following error warning messages.
Steps to Reproduce
Clarifying Information
Error Message2018-07-19 17:15:31.000691 ppid=0:pid=5992:16c8: 1768:16c8 ENTER SQLErrorW
HENV 0x0000000000000000
HDBC 0x0000000000000000
HSTMT 0x00000000056B2990
WCHAR * 0x00000000052CF3C0
SDWORD * 0x00000000052CF354 (0)
WCHAR * 0x00000000052CF3D0
SWORD 511
SWORD * 0x00000000052CF350 (100)

2018-07-19 17:15:31.000691 ppid=0:pid=5992:16c8: 1768:16c8 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 0x0000000000000000
HDBC 0x0000000000000000
HSTMT 0x00000000056B2990
WCHAR * 0x00000000052CF3C0 [ -3] "01004"
SDWORD * 0x00000000052CF354 (0)
WCHAR * 0x00000000052CF3D0 [ 100] "[Informatica][ODBC SQL Server Wire Protocol driver"
SWORD 511
SWORD * 0x00000000052CF350 (100)
Defect Number
Enhancement Number
Cause
Error code  "01004" means "String data, right truncated' , which means that the application was not binding the columns with the appropriate type and length.
The cause for the delay was due to the occurrences of these hundreds of thousands of error warning messages.
Resolution
After binding the columns with correct type and length in the application, the performance problem was resolved.
Workaround
Notes
Last Modified Date8/22/2018 6:36 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.