View Incident Report

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)}) <> '0.0.0.463' ORDER BY
InstalledApplication.Version

Resolution

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

Products Affected

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap