Home -> Usenet -> comp.databases.oracle -> Accessing Oracle DB in VC++

Accessing Oracle DB in VC++

From: Laurence Maar <lion_at_engineering.ucsb.edu>
Date: 1999/09/01
Message-ID: <Pine.SGI.4.02.9909011445170.5609-100000_at_silicon.ucsb.edu>#1/1 







  I'm currently trying to create a program in VC++ (6.0 Enterprise)
  to query my companies DB. I've figured out how to access an entire
  record using the CRecordSet base class, however I want to modify the
  SELECT statement to narrow down my search since obviously I dont want to
  grab the entire database and MoveNext() through the whole damn thing.



  I've tried:



        PDriver x;


	LPCTSTR str = "SELECT A00_PNUM, A06_EDITION, A4V_AGE_LICENSED, 
	B41_BIRTHDATE, B42_AGE FROM PDRIVER";

	x.Open(AFX_DB_USE_DEFAULT_TYPE, str);





  where Pdriver is a CRecordSet class and PDRIVER is the table name, but
  when I run this code on the call to Open() I get the error:
  "Invalid Descriptor Index"



  To which I have no idea what this means, nor is the MS Library help
  any help along those lines.



  Any advice? Thanks in advance.



  Laurence




Received on Wed Sep 01 1999 - 00:00:00 CEST












Original text of this message