RDBMS-INdependent application development

Hello everyone,

I'm working on a project that is written in C++ w/ embedded SQL. The project was originally developed with Informix, but we'd like to support users that already have Sybase or Oracle licenses so they won't have to buy Informix (thus making our project more desirable).

Now I know that there is an SQL standard, but how closely do any of the three vendors above follow that standard? For that matter, is there more than one standard and which ones are followed by whom? Ideally, the SQL that was written for Informix is 100% compliant and that I could just run our source thru Oracle and Sybase 'pre-compilers' (yeah, right).

On a slighly different path, there MUST be some 3rd party and/or PD C++ classes that encapsulate the RDBMS-specifics and provide a consistent C++ API. Any pointers to these packages will be greatly appreciated.

Any comments and pointers on the general task at hand will be appreciated as well.

I'll post a summary of responses if I get more than 3.

-Dave

PS I'm a newbie at this... Received on Thu Oct 20 1994 - 18:19:34 CET