Database operation in VC++

[maharaja pandian]

hi, i want to develop one application in VC++ MFC ,which can insert & retrive data from a database(oracle), through a dll .The Dll is resposible for handling all database operation. can any please help to work on that... "EXE" + "DLL" + "DB" 1.how can i make a connection string for oracle database which is in remote system. 2.how can i handle DB opeartion in Dll. i try with Dll , but it through error send reply ,,,early :) Try again and again, At last you will say I don't know the meaning for impossible.,. -- modified at 11:37 Wednesday 7th June, 2006

[David Crow]

maharaja pandian wrote:

i try with Dll , but it through error

And that error would be what?

---

"The largest fire starts but with the smallest spark." - David Crow

"Judge not by the eye but by the heart." - Native American Proverb

[PJ Arends]

DavidCrow wrote:

And that error would be what?

You sure are nosey, aren't you:doh:

---

You may be right
I may be crazy
-- Billy Joel --

Within you lies the power for good, use it!!!

[maharaja pandian]

in the Dll file when i try to open DB using the below function it work but when i try to open the recordset open i.e.,rsOpen() , it open a DataSource dialog screen will opened ,instead of executing a sql query ////////////////////////////////////////////////////////////////////////// bool CDaoDB::dbOpen(CString strFilePathName) { try { db = new CDaoDatabase(NULL); db->Open(strFilePathName); return true; } catch(CDaoException* error) { delete db; db = NULL; LPTSTR errors = ""; error->GetErrorMessage(errors,100,NULL); AfxMessageBox(errors); return false; } } bool CDaoRS::rsOpen(CString sql,CDaoDatabase* db) { CDaoTableDef *df; try { if(db) { rs = new CDaoRecordset(db); rs->Open(dbOpenDynaset,sql); return true; } else { AfxMessageBox("There is no current database open."); return false; } } catch(CDaoException* error) { delete rs; rs = NULL; LPTSTR errors = ""; error->GetErrorMessage(errors,100,NULL); AfxMessageBox(errors); return false; } } Try again and again, At last you will say I don't know the meaning for impossible.,.

[David Crow]

maharaja pandian wrote:

LPTSTR errors = ""; error->GetErrorMessage(errors,100,NULL);

This will likely fail as no memory has been made available for GetErrorMessage() to write the error message to.

maharaja pandian wrote:

rs->Open(dbOpenDynaset,sql);

What is the value of sql? Have you stepped into this method to see what is prompting the Open dialog to be displayed?

---

"The largest fire starts but with the smallest spark." - David Crow

"Judge not by the eye but by the heart." - Native American Proverb