Connect to DB with Windows App

[Victorb17]

I am building a windows app, and need to connect to a Microsoft Access
Database. How might I go about doing this? I know sql if that helps any.
I am using Dev C++ and writing in C

[David Schofield]

On Tue, 05 Oct 2004 17:10:24 -0400, "Victorb17" <vi*******@isp.com>
wrote:

I am building a windows app, and need to connect to a Microsoft Access
Database. How might I go about doing this? I know sql if that helps any.
I am using Dev C++ and writing in C

Hi
I have used ODBC. I know this is now deprecated by Microsoft, but so
is the Jet database which I take it is what you want to connect to.
The advantage of ODBC is that you can later swap easily to other dbs
including all the other free ones.
David

[Victorb17]

I'm not exactly sure how to do that either? if you could post some example
code that would be great. I'm still learning everything and any help is
much appriciated! Thanks!

[David Schofield]

On Wed, 06 Oct 2004 13:30:27 -0400, "Victorb17" <vi*******@isp.com>
wrote:

I'm not exactly sure how to do that either? if you could post some example
code that would be great. I'm still learning everything and any help is
much appriciated! Thanks!

Hi
Looking back I'm not sure what is the right advice. Originally we used
ODBC via MFC which was fairly straightforward, mainly connecting and
running SQL. Using via ODBC directly, which I did using lcc, is much
more fiddly and I see I only really used SQLExecDirect.

ADO is much less fiddly than ODBC but needs Microsoft
compilers/headers and won't be easy to get working with Dev-C++.

Some databases have their own C API, eg mySQL, which might be easier
to use. Also SQLLite I believe.

There are ODBC examples, on which I based my own code, in MSDN. See
particularly the SQLConnect Function and example, at

http://msdn.microsoft.com/library/de...sqlconnect.asp

the SQLExecDirect Function, and the SQLGetData function and example.
HTH
David