ID: Q125037
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).
The ESQL for C precompiler (SQLPREP.EXE and NSQLPREP.EXE) is not correctly generating the .BND output file for queries that perform data modification.
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.
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.
Additional query words: Windows NT
Keywords : kbprg SSrvESQL_C
Version : 4.22 | 4.22 | 4.22
Platform : MS-DOS OS/2 WINDOWSLast Reviewed: May 1, 1997