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

> 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

Hi Peter,

thanks you very much for your suggestions. I am considering writing a Win32 DLL helping me to connect to an Oracle Server; the DLL will work as an Interface for another complex Environment with the ability to execute scripts an calling extern programs/DLLs. So performance/little overhead is an issue. The OS is limited to the Win32 family (W2k,XP,2k3,...)

The access to the Oracle SQL Database is already specified by the customer with 2 different tables and DBMS_PIPE(s) for interprocess communication/signalling to other 3rd party applications. As I am new to the actual Oracle versions and the Concept of a PIPE (which don't exist on MS SQL), I need some advice finding the best way to do so. I have now read something about the Oracle C++ Call Interface (OCCI), but I don't know, if this would be a good aproach or if I should stay with ODBC. Can I call DBMS_PIPE functionally by using ODBC? e.g. can I adopt existing MFC MS SQL ODBC code, change the connection string and execute SQL strings, calling Oracle Functions?

TIA
Rainer Received on Wed Dec 01 2004 - 02:42:24 CST