Click here to Skip to main content
15,902,891 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Gdiplus::Graphics::DrawString and word wrap Pin
Luc Pattyn5-Mar-10 6:41
sitebuilderLuc Pattyn5-Mar-10 6:41 
Questioncommunicate with usb (MTP) device and IOCTL Pin
Tinf73784-Mar-10 21:54
Tinf73784-Mar-10 21:54 
QuestionConnecting to a Server Database Pin
jannathali4-Mar-10 21:47
jannathali4-Mar-10 21:47 
QuestionRe: Connecting to a Server Database Pin
David Crow5-Mar-10 7:09
David Crow5-Mar-10 7:09 
QuestionDifference between AVIStreamWrite and AVIStreamWriteData Pin
gmallax4-Mar-10 21:12
gmallax4-Mar-10 21:12 
AnswerRe: Difference between AVIStreamWrite and AVIStreamWriteData Pin
Richard MacCutchan4-Mar-10 21:19
mveRichard MacCutchan4-Mar-10 21:19 
GeneralRe: Difference between AVIStreamWrite and AVIStreamWriteData Pin
gmallax5-Mar-10 20:04
gmallax5-Mar-10 20:04 
QuestionMFC + ORACLE Pin
MsmVc4-Mar-10 19:11
MsmVc4-Mar-10 19:11 
Hi all

I am trying to fetch data from ORACLE.Connection part is working.When i try to fetch the data then i am getting error.
Microsoft OLE DB Provider for Oracle Error: -2147467259
Data type is not supported.
Unspecified error

I am trying give some details.

Table
CREATE TABLE "SYSTEM"."TEST" ( "OID" RAW(16), "EVENTID" NUMBER NOT NULL ,
 "NAME" VARCHAR2(30) NOT NULL , "TABLE_OBJNO" NUMBER NOT NULL ,
 "USAGE" NUMBER NOT NULL , "ENABLE_FLAG" NUMBER NOT NULL , 
"MAX_RETRIES" NUMBER, "RETRY_DELAY" NUMBER, "PROPERTIES" NUMBER, 
"RET_TIME" NUMBER, "QUEUE_COMMENT" VARCHAR2(2000),
 "SUBSCRIBERS" "SYS"."AQ$_SUBSCRIBERS", "MEMORY_THRESHOLD" NUMBER,
 "SERVICE_NAME" VARCHAR2(64), "NETWORK_NAME" VARCHAR2(256),
 CONSTRAINT "AQ$_QUEUES_CHECK" UNIQUE ("NAME", "TABLE_OBJNO") VALIDATE ,
 CONSTRAINT "AQ$_QUEUES_PRIMARY" PRIMARY KEY ("OID") VALIDATE ) TABLESPACE "SYSTEM" PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING


Through this way i am trying to fetch the data.
CString tabledetail="Select utl_raw.cast_to_varchar2("OID"),"EVENTID","NAME",
"TABLE_OBJNO","USAGE","ENABLE_FLAG",
"MAX_RETRIES","RETRY_DELAY","PROPERTIES","RET_TIME","QUEUE_COMMENT",
"SUBSCRIBERS","MEMORY_THRESHOLD","SERVICE_NAME","NETWORK_NAME" from system.TEST";
try
{
	pRecordset=m_pConn->Execute(_bstr_t(tabledetail), 0, adCmdText);
}
catch(_com_error pCE)
{
	CString error;
	error.Format(_T("\n%s Error: %ld\r\n%s\r\n%s\r\n"),(TCHAR*)pCE.Source(),pCE.Error(),(TCHAR*)pCE.Description(),(TCHAR*)pCE.ErrorMessage());
	AfxMessageBox(error);
}

Please help me where i am wrong.
AnswerRe: MFC + ORACLE Pin
Garth J Lancaster4-Mar-10 22:04
professionalGarth J Lancaster4-Mar-10 22:04 
GeneralRe: MFC + ORACLE Pin
MsmVc4-Mar-10 22:13
MsmVc4-Mar-10 22:13 
GeneralRe: MFC + ORACLE Pin
Garth J Lancaster4-Mar-10 22:30
professionalGarth J Lancaster4-Mar-10 22:30 
GeneralRe: MFC + ORACLE Pin
MsmVc4-Mar-10 22:35
MsmVc4-Mar-10 22:35 
GeneralRe: MFC + ORACLE Pin
MsmVc4-Mar-10 22:41
MsmVc4-Mar-10 22:41 
GeneralRe: MFC + ORACLE Pin
Garth J Lancaster4-Mar-10 23:07
professionalGarth J Lancaster4-Mar-10 23:07 
GeneralRe: MFC + ORACLE Pin
MsmVc4-Mar-10 23:11
MsmVc4-Mar-10 23:11 
GeneralRe: MFC + ORACLE Pin
Garth J Lancaster4-Mar-10 23:15
professionalGarth J Lancaster4-Mar-10 23:15 
GeneralRe: MFC + ORACLE Pin
MsmVc7-Mar-10 18:33
MsmVc7-Mar-10 18:33 
QuestionHWND From Procedd ID Pin
john56324-Mar-10 19:00
john56324-Mar-10 19:00 
AnswerRe: HWND From Procedd ID Pin
Adam Roderick J4-Mar-10 19:14
Adam Roderick J4-Mar-10 19:14 
GeneralRe: HWND From Procedd ID Pin
john56324-Mar-10 19:20
john56324-Mar-10 19:20 
AnswerRe: HWND From Procedd ID Pin
Eugen Podsypalnikov4-Mar-10 19:21
Eugen Podsypalnikov4-Mar-10 19:21 
GeneralRe: HWND From Procedd ID Pin
john56324-Mar-10 19:37
john56324-Mar-10 19:37 
GeneralRe: HWND From Procedd ID Pin
Eugen Podsypalnikov4-Mar-10 19:46
Eugen Podsypalnikov4-Mar-10 19:46 
GeneralRe: HWND From Procedd ID Pin
john56324-Mar-10 19:55
john56324-Mar-10 19:55 
GeneralRe: HWND From Procedd ID Pin
Eugen Podsypalnikov4-Mar-10 20:17
Eugen Podsypalnikov4-Mar-10 20:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.