Connection to MS Access Database

[WinAPILearner]

Dear All, I am developing a Win32 Application in Windows API VC6.0, I need to use an MS Access 2000 Database to connect to. Reading some of the Articles on codeproject site, but could not decide what is the best to use: ADO COM DAO ODBC My Appliction need to run smootly on Windows 9x, 2k and XP? ======================= Just reading the Article: Express OLE DB Library: An ideal data access solution for C++ By Ghanshyam Naik, I decided to use ODBC for my project. Any help is appreciate to connect to MS ACCESS using ODBC (NOT MFC) or using MFC Classes in Win32 and Win API Programming. WinAPILaerner

[David Crow]

WinAPILearner wrote: ...but could not decide what is the best to use: "Best" is a subjective term. It all depends on what you are after as to what technology you would use. How big is the database? How many connections are you expecting to support? Can the database be accessed by more than one connection at a time? How many transactions-per-second do you expect? Does the database need to be backed up while in use? This is not an all-inclusive list of questions. WinAPILearner wrote: Any help is appreciate to connect to MS ACCESS using ODBC (NOT MFC) or using MFC... You want to connect to an Access database without using MFC, but you want help with MFC. Is that correct?

---

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

[WinAPILearner]

Dear David Crow, I would like to use ODBC, Win API in a Win32 Application, my Database is just a catalog. Select ProductID in listbox and then Show Other Information in a Static text windows. I found this Interesting Article but it is MFC, I want the same thing in Win API. href="http://www.codeproject.com/database/readdb.asp#xx467253xx"> Using the CDatabase class to read an Access databases I posted my code to the author, I will appreciate if you have a look at. Thanks

[David Crow]

WinAPILearner wrote: I would like to use ODBC, Win API in a Win32 Application, Check out functions like, but not limited to:

SQLGetData
SQLExecDirect
SQLFetch
SQLPutData
SQLConnect
SQLSetParam
...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc\_api\_reference.asp

---

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