ECDA Option for ODBC

Table 5 lists the issues that were fixed for ECDA Option for ODBC.

Table 5: Description of software fixes for ECDA Option for ODBC

Target DBMS

Description

Resolution

QTS #

All

AddWinService.bat Windows Service Method no longer supported.

The ServiceWrapper.exe method replaces AddWinService.bat method to run ECDA as a Windows Service.

469450

Changes to CIS for ASE release 15.0.1 require ECDA 15.0 changes to take advantage of the optimizer

Adds support for the convert function in SQL transformation.

469044

The connection test utility, odbct, results in segmentation fault

Updated driver manager load mechanism

462951

Stopping the Windows service leaves an orphaned directc.exe process in Task Manager

Modified stop service handling to correctly clean up the server

455831

A template transfer using a stored procedure failed.

Sybase now supports stored procedures in a template transfer.

416251

A null character data caused SQL statement truncation.

Null characters and binary zeros in SQL statement are now stripped when the StripBinaryZero property is set.

291774

DB2 UDB

Incorrect date formatting occurred with only 3 digit years.

For DB2, dates are correctly formatted with all 4 digits.

421328

The sp_who stored procedure caused a segmentation fault in DB2.

Result handling was corrected to allow zero row result set for DB2 targets.

420094

SQL statements for DB2 containing SUBSTRING should be changed or transformed to SUBSTR.

SUBSTR is now used for DB2 targets.

402619

ASE/CIS cursor date parameter was bound as datetime for DB2.

The date parameter is now bound as date.

402362

Microsoft SQL Server

Replication of unitext fails

Added support for unitext data from Sybase Replication Server 15.0.

468731

WCHAR columns caused a failure in sp_columns.

WCHAR columns are now supported in sp_columns.

417657

ReturnNativeError = yes returned an error message instead of MSSQL error message.

ReturnNativeError = yes now returns a MSSQL error message.

404658

Null text column result failed when tracing was set to “on.”

The method of sending null result value is changed.

401899

The NTEXT datatype mapped incorrectly through ASE/CIS.

sp_columns is adjusted for NTEXT datatype and XNL settings.

392089

Conflicting datatype was returned in sp_columns when mapping Unicode to text.

The problem in sp_columns is fixed for both cspcolumnODBCVersion = 2 and 3.

354091