Icon View Incident Report

Serious Serious
Reported By: Matthew Reddick
Reported On: 5/5/2005
For: Version 4.19 Build 1
# 2042 ODBC Driver Not Parsing Escaped Functions Properly

SQL Parsing error that we are seeing:

Executing the following with 4.16 dbodbc.dll and 4.19 dbodbc.dll. With dbodbc.dll version 4.16, this statement executes correctly.

With dbodbc.dll version 4.19, this exact same statement gives the exception:

Caused by: java.sql.SQLException: [Elevate Software][DBISAM] DBISAM Engine Error # 11949 SQL parsing error - Expected ) but instead found ( in SELECT SQL statement at line 1, column 272

SELECT * FROM Workstations, InstalledApplication, Groups WHERE
Workstations.WorkstationsID = InstalledApplication.WorkstationsID AND
Workstations.GroupID = Groups.GroupsID AND InstalledApplication.Name =
'Spy Sweeper' AND SUBSTRING(InstalledApplication.Version, 13, {fn
LENGTH(InstalledApplication.Version)}) <> '' ORDER BY

Resolution Resolution
Fixed Problem on 5/6/2005 in version 4.20 build 1

Products Affected Products Affected
DBISAM ODBC Client-Server
DBISAM ODBC Client-Server with Source
DBISAM ODBC Standard with Source