Re: Using C++ with Oracle

"Jason" <dob260670_at_bigfoot.com> wrote in message news:9hn6ji$pt8$1_at_news8.svr.pol.co.uk...
> Hi,
>
> Im a complete newbie and Ive got a few questions (in no particular order)
> regarding connecting to an oracle datasource, particulary Oracle 8i
 Personal
> Edition:
>
> * Can anyone explain the function of "Listeners"? Do these have the same
> function as a server for the database? Can they be acessed through
> http://127.0.0.1:1521/?
>
> * What header files do I need to incorporate into my C++ source code in
> order to connect, so that I can run SQL statements?
>
> * Does anyone have example code for connecting to an Oracle datasource
 using
> C++?
>
> * How easy is ODBC to configure and use?
>
> I installed Oracle PE via a CDROM that came with an SQL book - even tho Im
> competent with SQL now :-) , Im having problems using the system with C++.
>
> Any help or pointers to info would be appreciated!!
>
> Cheers
>
> Jason
>
>

Please check out Oracle Objects for OLE, which comes *free* with any version of Oracle. It is a DAO like *native* interface, which can be called from Visual C and Visual Basic. Help files and samples are included. Compared to OO4O, ODBC is just a big Pain In The Ass, and it will always be much much slower than OO4O.

A listener is a process acting as a broker between your client and a database instance.
You can use the localhost address, but you need to configure them using the Net8 Configuration Assistant included in your install. They can not be accessed in the way you mention.

From the nature of your questions it looks like, your hacking away without reading any manual, or installation documentation. Please don't do so, you can't get Oracle up and running without reading manuals.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun Jul 01 2001 - 09:36:06 CDT