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 -> Re: NEWBEI->Oracle 7.3 WG Server and VC++ problems

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

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/18
Message-ID: <67b7ps$hts$1@news00.btx.dtag.de>#1/1

Alon Weinberg wrote:
>
> 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

Hi,

what we experienced using VB and Access is that oracle doesn't understand '[' and ']'. So dont't use them in any passthrough queries.

-- 
Regards

Matthias Gresz    :-)
Received on Thu Dec 18 1997 - 00:00:00 CST

Original text of this message

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