Re: Help Connecting to ORACLE from C++

Assuming that SensorData is the user and the user has select access to the system.TimeReading I would believe that this should work.

Try accessing a table that Sensordata owns.

You might want to not use a snapshot method.

Mike Krolewski

William Martin-Gill wrote:

> Hello,
>
> I am having a problem connecting to an ORACLE8 database from a C++
> program. I am using the Microsoft Foundation classes CDatabase to open
> the database in my program with the command--
>
> CDatabase db;
> try{
> db.Open(_T("SensorData"),FALSE, FALSE,_T("ODBC;"),FALSE);
> } catch( CDBException* e )
>
> It seems to work fine. But then when I try to open a table with the
> following code, it gives be an access violation error and shuts down.
>
> CRecordSet rs;
> try{
> rs.Open(CRecordset::snapshot,_T("system.TimeReading"));
> } catch( CDBException* e )
>
> I am trying to open the table TimeReading owned by system.
>
> Any help would be appreciated.
>
> William Martin-Gill
Received on Mon Jun 22 1998 - 00:00:00 CDT