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

Home -> Community -> Usenet -> c.d.o.misc -> NEWBEI->Oracle 7.3 WG Server and VC++ problems

NEWBEI->Oracle 7.3 WG Server and VC++ problems

From: Alon Weinberg <alon_at_inetrport.net>
Date: 1997/12/18
Message-ID: <3498a06c.16919639@news.interport.net>#1/1

This is jsut my first application using VC5++ and Oracle. I am working under NT4, and also upgrade my oracle ODBC drivers to ver2.05.0301. this is my DB access statements, while CCUstMstr is a class based on a recordset. The table that CCustMSt represent has few field, all of them are VARCHAR2, and the index is on a field called PIN_NO.

CCustMstr* m_pCustMstr;
CDatabase m_Database;
CDatabase * pDB = new CDatabase();
pDB->Open( _T( "testdb" ), false, false, _T("ODBC;UID=alon1;PWD=al"));

CCustMstr cstmst(pDB);
cstmst.m_strFilter = " [PIN_NO] = '11111111'"; try {

    cstmst.Open( CCustMstr::snapshot, _T( "Select [BALANCE] from     [APTTECH].[CUSTOMER_MASTER] " ) );
}

   catch( CDBException* e ) {

	sprintf(buffer,"DB ERROR %s",e->m_strError);
	EventCompletedUpdate(pObject,WM_Print_Message1,buffer);
   }
  1. when the cstmst.open methos is executed with CCustMstr::snapshot,

    as is in the example above, I got an error "Invalid descriptor     Index"

2. If I change the snapshot to dynaset, I get an error message

    "driver does not support dynasets"

I have no idea how to solve these problems. By the way, when I try using the Oracle ODBC TEST application, the one that comes with th oracle WG SERVER, I can update, select and everything.

Thanks,
Alon Weinberg
alon_at_interport.net Received on Thu Dec 18 1997 - 00:00:00 CST

Original text of this message

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