BUG: ESQL for C Precompiler /BIND Option Builds on SELECT

• Microsoft Embedded SQL for C Programmer's Toolkit, version 4.22

SYMPTOMS

The /BIND option on the precompiler for Microsoft Embedded SQL for C (ESQL for C) only builds the static stored procedures for SELECT queries. The /BIND option fails to create stored procedures for any data modification queries (INSERT, UPDATE, or DELETE).

CAUSE

The ESQL for C precompiler (SQLPREP.EXE and NSQLPREP.EXE) is not correctly generating the .BND output file for queries that perform data modification.

WORKAROUND

Use the /SQLACCESS option on the precompile of your ESQL for C application. If you need to transfer the stored procedures created by the precompiler to another SQL Server installation, use SQL Object Manager's schema generator to create a script file of the necessary stored procedures.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Embedded SQL for C Programmer's Toolkit version 4.22. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.