Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [Newbie] howto: accessing Oracle SQL by C/C++ Win32 Application

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

From: Rainer Hausbach <R.Hausbach_at_d-offline.de>
Date: Thu, 2 Dec 2004 09:03:12 +0100
Message-ID: <comi81$qmo$1@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

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 Thu Dec 02 2004 - 02:03:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US