Difference b/w sql.h ,sqlapi++.h and msado15.dll

[chnnaveen]

Hi,

I want to connect the my ms-access database file from the c++.currently i'm using the msado15.dll using import in VC++

I need to know is their any other way of accessing the database from c++.

on browsing, I came to know that sql.h ,sqltypes.h,sqlext.h are 3 header file to be add for database connectivity. and also I came to know we can use sqlapi 's i.e using sqlapi++.h

Is anyone explain the difference in all these 3 ways( using import dll ,sq.h and sqlapi++.h) and suggest me book /link to now more about database connectivity

[kbw]

You have to stop looking at header files and look at libraries. There's nothing to stop different libraries using header files of the same name.

[chnnaveen]

yes i know the purpose all these header files are same.

But is they are different library files from different providers or same.

[kbw]

slqapi++ is different from ODBC.

[chnnaveen]

thank's KBW,

Can u explain little bit more ..

[kbw]

SQLAPI++ is a general purpose SQL database access library with support for Oracle, SQL Server, and a few others. I looked promising when I looked at it, but it was incomplete.

ODBC is Microsoft's ubiquitous method of database access.