I'm using Microsoft SQL server and have a very simple test c program with embedded sql, but cannot get the sql precompiler (nsqlprep) to run.
I have set the correct environment variables for the c compiler and the location of the include files, but always receive the error (at the end of this message - lcc is the name of the c compiler) in the c program output by nsqlprep, at which point the precompiler exits.
I'm only using one c include file <stdio.h> and whether I include it with or without the path name, or leave it out altogether I always get the same error.
The information in the T-SQL and the internet is not helpful.
Error message from nsqlprep
lcc preprocessor error: c:\history\test_embedsql1.sqc:1 Syntax error in #include
Please enter the path for the <include> header files (for example c:\lcc\include)