Re: [Newbie] howto: accessing Oracle SQL by C/C++ Win32 Application

"Rainer Hausbach" <R.Hausbach_at_d-offline.de> wrote in message news:<coi2ou$168$1_at_mail1.sbs.de>...
> Hi Oracle gurus,
>
> I'am a little bit confused about the various ways to connect/interact with
> an Oracle SQl Database.
> Some years ago ( > 8), I did write an Application running under WfW 3.11
> connecting to a Novell NetWare 3.12 based Oracle 7.0.x Server.
> I was using a Pre Compiler Pro*C(?) v1.5 to produce C code which could be
> used with MS VC 1.51 / MFC 2.5 environment (those where the days...)
>
> Now: How to do this kind of tasks in a 'modern' Windows 32 bit environment?
> (VC 6/7, XP, Oracle v9.x / 10.x).
> I need to connet to some tables (select,update,insert) _and_ to the
> DBMS_PIPE facilites. What is the best Approach to this Task? PL/SQL ->
> 'Native Application Development'?
> Newer Version Pro*C? ODBC? ADO? DOA? COM??
>
> >Help!<
>
> TIA
> Rainer

Hi Rainer,
a tough questions because it depends on what you want to do and how you want to maintain it.

I had the same question 2 years ago, but I needed to also be cross database and cross operating systems as I was building an ETL tool for myself.......for me, the right answer was C++/ODBC for high performance, cross os, cross database and batch processing. You might not have the same needs.

The answer to almost every question today seems to be 'java'. I didn't use Java because of the poorer performance compared to C++. If you are developing GUI based stuff (non-batch) and you need cross platform I would guess java is a better way to go than C++. JDBC talks to everything. If you are using VS.NET you can use ADO.NET for disconnected access.....I'd stay away from COM, Pro*C, DOA if you are using VS.NET....MSFT has even stabalised ODBC now in favour of ADO.NET... Hope this helps....what exactly are you planning to write?

Best Regards

Peter Nolan Received on Tue Nov 30 2004 - 11:59:58 CST