Using Procedure Call in ODBC Generates a Syntax Error

Abstract: Using Procedure Call in ODBC Generates a Syntax Error

Problem: Trying to execute a stored procedure through the ODBC driver generates: ODBC error: [Visigenic][ODBC InterBase 4.1 Driver] Syntax error or access violation. Solution: IB V4.x visigenic InterBase ODBC driver v1.00.0809 This was a bug in version 1.00.0809 of the ODBC driver. The solution is to upgrade to version 1.00.0813 or later. Contact InterBase Technical Support for the ODBC driver upgrade. In the interim, you can use a different technique to call the procedure: select * from procedure_name (presuming this is a select procedure)