Application database independient.

[GMena]

Exist a technology that allow me develop an application database independient.
I mean is possible that one aplication can work with Access database (local) and
this will be able to work with SQL Server in necesary case.

Thanks in advanced.

GMena

[Fraser]

ODBC sounds like the one for you.

Investigate classes CDatabase, CRecordset, etc. in the MFC documentation.

You should be able to make your application database independent by utilizing this technology.

Hope this helps.

[Cih]

You may try OLE DB. This is newer technology, but if you find any problems it may be more difficult to solve them.

[Tomaz Stih]

NO.

Unless you are prepared to go with the smallest common denominator. MS SQL, ORACLE and ACCESS all use different SQL syntax, Access does not support triggers and stored procedures,...

On the other side if all you need are some queries (though even designing a single table can be a problem: how do you create primary key - sequence in Oracle, identity in MS SQL and autonumber in Access...) try using ODBC.

The way to access odbc is either via CRecordset or via OLE DB ODBC provider...All is the same in essence...

---------------------------------------------
Tomaz Stih, B.Sc.CS tomaz@nameco.com
Ob sotoccju 10 Nameco Group
SI-1000 Ljubljana http://www.nameco.com
Europe

[Avad]

You can use ADO. This will definitely help you.