i ever use ODBC (i know, that is no argument :-D), i think it is better. but i found my mistake. i forgot: db.Open(_T( "MyDatabase" ),false, false, "ODBC;UID=sa"); thanks for your reply. :rose::rose: mfc

thank you very very much.....:rose::rose::rose: i tried your idea.... CDatabase db; db.Open(_T( "Datenbank" ), FALSE,FALSE, _T( "ODBC")); CRecordset rs(&db); rs.Open(CRecordset::forwardOnly ,"Select distinct xy from Mytable"); i connectet access and vc++ with ODBC. the ODBC driver from my database i namend: 'Datenbank'. in my database i have different tables and one is called xy. in my code (above) must be a mistake....it doesnt work...why? :~ how can i get the strings which i read out of my database table? thank you. mfc

:) you can use some SQL tools(such SQL Server's Query Analyzer) which can chech you SQL statement, go, if you SQL statement is right that you can see the result for you query. My English is not good, but I can try my best for your problem.:cool: hi

do not name your class CDatabase, because CDatabase is a MFC-class and it's the best way to connect to database through CDatabase. then you create CRecordset-derived class and pass a pointer to database as a parameter. ExecuteSQL(...) is a method of MFC CDatabase class. class CMyApp: public CWinApp { CDatabase m_db; }; BOOL CMyApp::InitInstance() { m_db.Open(...); } void CMyView::Func1() // or something else { CMySet set(&theApp.m_db); set.Open(...); // etc... } Dmitry Timin

MFC is the Best wrote: the 'Close' is only an example.....sorry.....you are right. can you help me more? In what way ? Design ? Code ? I don't know exactly what you intend to do ? so this is highly speculative : If your application needs a password, it should be asked at the beginning, in a modal dialog, upon return of that dialog, if the password is wrong, you have the choice to either continue ( and you need to be able to check whether the password is valid or exists to block most operations with the ON_UPDATE_COMMAND_UI messages for menus and other type of check ) or quit. If you continue running the application, you need a menu item to allow the user to enter the password. Max.

thanks for reply. i think i know what you mean, but i don´t know, how i should program it. can you give me an example or explain it in more detail? thank you very much mfc

sorry i forgot: thank you very much.....great...

thank you very much

You need to do this: 1. Create a database object and open it. 2. Create a recordset object and open it. You send the SQL statement to the Recordset. 3. See CRecordset member functions for details how to insert, update and delete rows 4. You close the recordset and then the database. Best regards, Alexandru Savescu

it functions! thank you very much! :-D:-D MFC p.s.: i never find what i´m looking for in the msdn. :eek: :(

great, thanks.....:rose: only one small mistake: u wrote: for(int iColumns=0 ; iColumns

Didn't know that. For some reason, I though template templates where new to VC7. Thanks.;) Giles

MFC is the Best wrote: 120 111 34 44 (between every number is a blank) Why dont you just simply use CString::Find(' ', nStart) ? So you can iterate over the whole Line and by remembering the result of Find() you can reuse it in the next Find(). With CString::Mid(), you get the portion of the Text between the two finds.

Post the code from CYourApp::InitInstance Tomasz Sowinski -- http://www.shooltz.com *** Vodka. Connecting people. ***

everything is okay.....found the mistake, thany you :rose::rose::rose:

Thank you very much! :rose: :rose: :rose: MFC is the Best