problem in inserting image into the database

[maharaja pandian]

hi, i develop one application in VC++-MFC 6.0 , this application is responsible for inserting image into the database (oracle)-ODBC. but when i try to insert a image file , it through a error like "Data type conversion error." //////////////////////////////////////////////////////////////////////// CDaoDatabse db; CDaoRecordset recset(&db); void CDBODBC::InsertintoDB(); { CByteArray BlobFile; BlobFile.RemoveAll(); // I clear the Array CFile aFile("image.jpg",CFile::modeRead); BlobFile.SetSize(aFile.GetLength()); aFile.Read(BlobFile.GetData(),aFile.GetLength()); aFile.Close(); COleVariant aVar(BlobFile); CString Sql = "SELECT * FROM sample3"; db.Open("abc",FALSE,FALSE,"ODBC;UID=abc;PWD=abc;DSN=abc;"); recset.Open(AFX_DAO_USE_DEFAULT_TYPE,Sql,dbAppendOnly); // bool b=recset.CanUpdate(); recset.AddNew(); recset.SetFieldValue("[num]","6"); //varchar field recset.SetFieldValue("[photo]",aVar); //BLOB field -image field recset.Update(); recset.Close(); db.Close(); } ///////////////////////////////////// it works for Access database .. but i got error in oracle... "Data type conversion error." Try again and again, At last you will say I don't know the meaning for impossible.,.

[stefanmihaimoga]

The solution you may found it in Shekar Narayanan's Using CLongBinary for BLOBs[^] :)

[maharaja pandian]

tnx, but , it is MSACCESS database with the column datatype of "OLE Object" so using COleVariant class,we convert the image as bytestream to COlevariant.. but i want to do the same thing for oracle ..with the column datatype "BLOB" here also i create same COleVariant ,but it doesn't acceptable by database field "BLOB"..... "Data type Conversion error" Try again and again, At last you will say I don't know the meaning for impossible.,.