I found a sample program (Embedded SQL C for SQL Server 2000) in the installables of MS SQL Server 2000.I ran it against MS SQL Server 2005 and I got this error.
Running ESQL/C precompiler
'nsqlprep' is not recognized as an internal or external command,
operable program or batch file.
Error executing c:\windows\system32\cmd.exe.

genchar.exe - 1 error(s), 0 warning(s)

Through internet, I found that before using nsqlprep we have to take initial steps i.e.,we have to run vcvars.bat(found in C:\Program Files\Microsoft Visual Studio\VC98\Bin directory) and setenv.bat(found with the sample program) form the command prompt.I have ran those batch files.But I am still getting above mentioned error.Before running I have edited the setenv.bat and set the path of the INCLUDE and LIB to the locations where I have placed the w95scm.lib and wn95scm.h,which I got from the installables of MS SQL Server 2000.

Note:I have ran this program through Visual Studio 6.0.

There are some issues of compatibility of SQL Server 2005 with Embedded SQLC.He says MS SQL Server supports SQL Server 2005 but future versions of SQL Server might not support it.Moreover,the above mentioned .lib and .h files I took it from the installables of MS SQL Server 2000 not from MS SQL Server 2005.There is only one directory lib(one .lib file found) in SDK folder in the installables of MS SQL Server 2005.