Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> NEWBEI->Oracle 7.3 WG Server and VC++ problems
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);}
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