Depends upon whether your SQL is static or not. And ... I don't believe MS or
Oracle support embedded SQL. You may want to take a more dynamic approach and
look at the CLI interface.

Larry Edelstein

Tomasz wrote:

> Hi all
> We plan to write large application (sales, purchase, accounting) in C/C++.
> It will work with DB2 and other databases (MS SQL and Oracle). Client will
> work under Win and Linux, so ADO and OLE DB aren't solution.
> It seems ESQL standard is the only solution that allows to write such
> application once and connect to different databases. Is this good choice? Is
> this fit for serious application? Will it be supported in the future?
> In your opinion, which API would be the best solution?
>
> your help would be greatly appreciated
> Tomasz