Reported By: Johnny McRae Reported On: 2/7/2012 For: Version 2.07 Build 1
# 3543Using 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
CommentsThe problem was with the DescribeParam call in the ODBC Driver, which was not properly declared.
ResolutionFixed Problem on 2/9/2012 in version 2.08 build 1
Products AffectedElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial