connec tion to ms access database

[tejaswi teja]

hi canu please tell me h ow to connect to a database created in microsoft access and acces data sign CDatabase class.

[ThatsAlok]

tejaswi_teja wrote: tell me h ow to connect to a database created in microsoft access and acces data sign CDatabase class. Have a look here :- Access Database using CDatabase class[^]

"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow

cheers, Alok Gupta VC Forum Q&A :- I/ IV

[vikas amin]

Here is a small code from a project for u CDatabase database; CString SqlString; CString sDeviceID,sDeviceName,sStatus; CString sDriver = "MICROSOFT ACCESS DRIVER (*.mdb)"; CString sDsn; CString sFile = "D:\\PMR\\vc++\\conndevices.mdb"; // You must change path if it's different database // Build ODBC connection string sDsn.Format("ODBC;DRIVER={%s};DSN='';DBQ=%s",sDriver,app_path); // Open the database database.Open(NULL,false,false,sDsn); CRecordset recset( &database ); // Build the SQL statement //DeviceOpen::m_devicename.GetWindowText(sDeviceName); SqlString="SELECT DeviceName FROM conndevices "; // Execute the query recset.Open(CRecordset::forwardOnly,SqlString,CRecordset::readOnly) Vikas Amin Embin Technology Bombay vikas.amin@embin.com

[David Crow]

This might help.

---

"One must learn from the bite of the fire to leave it alone." - Native American Proverb

[tejaswi teja]

thank you all very much