Urgent!!! Database Access in C++

Hi Everyone,

I am trying to write a service in an ATL object project where I need to access an access database via the code. I know that the normal method is to start with the DAO class CDaoDatabase.

I tried:

CDaoDatabase* MyDB;

But C++ always returns the error "Expected ';' after CDaoDatabase" when I try to build it, I have no idea of where to go next. Please Help!?!

Thanks a mil in anticipation.

Needaname16.

CDaoDatabase is an MFC class and can't intrinisically be used in ATL (which defies the principle of using ATL if you're just going to use MFC anyway :p).

You can use #import to do this, but I don't have any more info other than the name (never used it, didn't need to since I don't use COM through C++).

I looked up the import in the help and I understand what parksie means, however like him I have never tried this before and I wouldn't have a clue as to what file I need to import to get access to Access Databases. PLEASE!!!!!!! has anyone got any advice as to how I could achieve this.

Or does anyone have any idea of how to convert a normal MFC app in C++ to a service for WinNT.

(Surely someone has done something similar in the past)

PLEASE!!!!:confused:

Thanks
Needaname16

There are also ADO, OLE and ODBC database access methods...

Could any of you please tell me how to use and initialize the MS Access Engine? I would like to use it to store a bit of information like:

My Name
My Age
My Gender

and available for many entries.

Thanks a lot:)

engine???

You know just how to use MS Access to input info and then output it.

I only dabbled in databases with vb but you have to create one first with all the places for data....I don't think you create the actual file in code though....

Can you tell me how do you input and output in ASP Code?(MS Access)