Oracle Pro*C/C++ precompiler with C++

Hi,

For our huge 3-tier application, being developed using Visual Studio 6.0, we are using embedded SQL compiled with Pro*C/C++ instead of ODBC. This choice was founded on the stability and better performances of embedded SQL.

Is anybody else, on this planet, also using embedded SQL in a C++ development? Have you any judgment on the choice we made? Are latest versions of ODBC stable and fast enough to develop big applications? And, last but not least, are you also experimenting problems while integrating embedded SQL in your code (lack of useful examples in the oracle doc, etc.)?

Opinions, discussions and answers or related links to any helpful documentation are all welcome!

Bertil

[Charlie Curtis]

Hi,

I have been developing an application for awhile now and would have answered sooner, but I needed to do some testing first! I to had a few Apps developed in Pro*C and have made the following determinations based on what I have accomplished with MS Visual C++ 6.0 since your post.

When I originally design my current Application using ODBC I found it to be Extremely slow and was about to redo it in Pro*C again, but I started asking questions on this site and found that (THANKS TO Mr. Rail Jon Rogut and Mr. Keller Beyer III) following there examples I was able to create the Application fully in Visual C++ 6.0. To my great relief. I don't mind Pro*C and am comfortable with it, but Visual C++ is pretty much self contained and if they get the ODBC drivers to the point of having all of the current SQL functionality as does the Pro*C. There wouldn't be much need for Pro*C any more. However, Pro*C is (in my opinion) more suited to Applications where considerable input, updates etc are needed. Since my Application is basically a Report generator (sometimes 800-1000 pages) Visual C++ is suitable and just as fast as the Pro*C is.

My opinion is that if you can make it work using Visual C++ I think you are better off! I'm sure there are those who may disagree, but you asked for opinions and mine is just one.

Hope this helps!
Charlie