BUG: ESQL for C Precompiler /BIND Option Ignored

• 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) is ignored at run-time. All queries sent to SQL Server by the ESQL for C application are dynamic queries.

CAUSE

The ESQL for C precompiler (SQLPREP.EXE and NSQLPREP.EXE) is building the application as if it was compiled for dynamic access (/SQLNOACCESS) to SQL Server access.

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.