Feedback
Did this article resolve your question/issue?

   

Article

When DataDirect drivers used SQLDriverConnect to connect, using curly braces to specify connection parameters, resulted in buffer ratios that were 3 times larger than without curly braces.

Information

 
TitleWhen DataDirect drivers used SQLDriverConnect to connect, using curly braces to specify connection parameters, resulted in buffer ratios that were 3 times larger than without curly braces.
URL Namewhen-datadirect-drivers-used-sqldriverconnect-to-connect-using-curly-braces-to-specify-connection-parameters-resulted-in-buffer-ratios-that-were-3-times-larger-than-without-curly-braces
Article Number000113769
EnvironmentProduct: Connect64 for ODBC SQL Server wp driver, DB2 driver, Sybase wp driver, Teradata driver, Informix driver
Version: 7.1, 8.0
OS: Linux x64, Win x64, Solaris SPARC 64, Solaris x64, HP
Database: SQL Server
Application: All supported applications
Question/Problem Description
When using SQLDriverConnect to connect to the SQL Server Database from an Oracle gateway application and provides the connection parameters with curly braces and without curly braces,
it resulted in buffer ratios that were 3 times larger than without curly braces.
For example:
In a SQLColAttribute call, printing out the buffere size for the same column -
Without curly brace -  OWNER NOT NULL VARCHAR2(30)
With curly brace  -      OWNER NOT NULL VARCHAR2(90)
Steps to ReproduceIt is a very specific recreation using Oracle gateway env .
The details of the repro is given in the defect description.
Clarifying Information
Error MessageN/A
Defect NumberDefects XDBC-15816, XDBC-15920, XDBC-15921, XDBC-15922, XDBC-15923, XDBC-15924
Enhancement Number
Cause
The driver code was not parsing correctly  the curly brackets around the connection parameter IANAAppCodePage value.
Resolution
Fixed in hot fix 07.16.0438  for SQL Server Wire Protocol Driver.
Fixed in hot fix 08.02.0269  for SQL Server Wire Protocol Driver.
Fixed in hot fix 07.16.0316  for DB2 Driver.
Fixed in hot fix 07.16.0244  for Sybase Wire Protocol Driver.
Fixed in hot fix 07.16.0127  for Teradata Driver.
Fixed in hot fix 07.16.0104  for Informix Wire Protocol Driver.

Refer to " Connect and Connect64 for ODBC hot fix download and install instructions " for instructions on how to download and install the hot fix.
Workaround
Notes
Last Modified Date11/5/2019 5:55 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.