>I have a problem connect to ORACLE database using MFC CDatabase.
>I can connect using MS Query and return data to the Excel SpreadSheet.
>Anyone out there have any success connecting to ORACLE using the ODBC
>driver downloaded from ORACLE Forum?
If you use ClassWizard to create a new class, of type CRecordSet, do you get a
connect then? It should ask you for an ODBC source, then connect to the
selected source and show a list of tables, from which you can select the one to
attach to the class.
If you can get this far, I would guess that its not ODBC as such thats the
problem, but rather the way you've set up your CDatabase class. I've not used
Oracle on a PC, so I can't help you further, but hopefully this may help you
isolate the problem.
Cheers,
Peter Connolly
Fraser Williams Ltd,
Leicester
England