Icon View Incident Report

Serious Serious
Reported By: Johnny McRae
Reported On: 2/7/2012
For: Version 2.07 Build 1
# 3543 Using Parameterized SQL Statements with the ODBC Driver and MS Excel Causes AV

Using Windows 7 64bit, Excel 2010 and ODBC Driver 2.07 b1

Am used to using odbc within excel with dbisam but have just moved over to EBD in recent weeks.

In EDB, I am able to perform basic Statements such as the following

However, as soon as I use 'WHERE ID = ?' Excel will crash. It crashes when using 32 Bit DSN or 64 bit DSN.

SELECT * From Products WHERE ID = 4545 

Comments Comments
The problem was with the DescribeParam call in the ODBC Driver, which was not properly declared.

Resolution Resolution
Fixed Problem on 2/9/2012 in version 2.08 build 1

Products Affected Products Affected
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial