Problem with Embedded SQL and Oracle Lite

I am using Oracle Lite version 3.0.5.1.6 on Windows 95. I am trying to use the esql.exe Embedded SQL precompiler on the example source files given in the distribution. I am using Visual C++ 4 as recommended in the release notes, to compile the resultant .c files.

I have tried compiling the first example, esqldyna.sc. Esql runs fine on it, but the make fails when it tries to compile esqldyna.c. It says it cannot find a header file called "wsapi.h". I searched my system, and the Oracle Lite CD. No sign of it. I searched on one of our systems that has an older version of Visual C++. It's not there either.

This is looking like a bug to me. Has anyone been able to get around the problem? The problem is caused by esql putting an include reference in the resultant .c file for sqlapi.h. Sqlapi.h includes okapi.h. Okapi.h attempts to include wsapi.h, and the compile fails.

I have tried commenting out the wsapi.h reference, but this causes other problems. I start getting errors related to missing macro definitions.

Is Embedded SQL not fully implemented yet for Oracle Lite? I noticed that there was no documentation on how to configure things for use with esql. I just had to figure it out from a make file in the examples\esql directory. The other programming environments: Power Builder, Visual Basic, etc. were documented better.

Perhaps I should just use Java?

---Mark
mmiller_at_nyx.net Received on Fri Jan 30 1998 - 00:00:00 CST