Oracle describe

[rdop]

Hi All I have a problem to use command "describe tablename" in mfc vc++."Describe tablename" is working well in oracle SQl plus. Here is code

_ConnectionPtr m_pConn;
_RecordsetPtr pRecordset;

m_pConn->Open (_bstr_t ("Provider=OraOLEDB.Oracle;PLSQLRSet=1;Data Source=orcl"),_bstr_t ("system"), _bstr_t ("password"), adModeUnknown);
pCommand->ActiveConnection = m_pConn;
CString fileddetail="describe supplier";
pRecordset=m_pConn->Execute(_bstr_t(fileddetail), 0, adCmdText);

Error is here

OraOLEDB Error: -2147217900 ORA-00900: invalid SQL statement IDispatch error #3092

Connection part is working well. I know some member told me this is a DBA forum question why you post here.But one thing describe or DESC command is working well in oracle.So i think it's a question of MFC VC++. Please help me

[xushih]

The Error messages means there is not this accout in the security database.Please check out the database accout name is right or wrong,espicaly look at using space in string or not.