Microsoft KB Archive/125037

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

PSS ID Number: 125037

Article Last Modified on 12/15/1999

-

The information in this article applies to:


 * Microsoft Embedded SQL for C Programmer's Toolkit 4.22

-



This article was previously published under Q125037



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.

Additional query words: Windows NT

Keywords: kbprogramming KB125037

Technology: kbAudDeveloper kbSQLeMCPTK422 kbSQLEmCPTKSearch kbSQLServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.