Oppolzer - Informatik / Blog

J.C. wrote:

Do you have access to the MSDN Library. Use "precompiler" as the
search term and get "[t]he nsqlprep precompiler creates a C program
with the file extension .c from an Embedded SQL for C (ESQL/C)
program".

Toddle over to, for example, http://www.openitx.com/g/sql-server-
l.asp for a better forum for such questions.

J.C.

On 10 Sep 2003 at 23:23, Bernd Oppolzer wrote:

> Hello DB2-Listers,
>
> we are creating a new application, which should be able to run with several
> different databases. We do this by specifying the SQL statements separated from
> the C coding, and then we generate different "access modules" for the different
> DB engines. The application layer does not see the differences.
>
> We have generator programs for DB2, ORACLE, and MySQL (which is very
> different, but it works, somehow). We now want to add support for MS SQL
> Server.
>
> Does someone know, if MS SQL Server has a precompiler and the EXEC SQL
> facility, like DB2 and ORACLE, or, does it have special API calls, like
> MySQL and OCI (Oracle Call Interface), or, is ODBC the only way to access
> the SQL Server databases (we don't like ODBC)? Where can we get
> more informations, books etc.?
>
> Any help is appreciated. Thanks, regards
>
> Bernd
>
>
>