ODBC API stuff
-
G'day, I'm thinking of porting one of our apps from DAO to ODBC for database access. I understand the correlation between CDaoDatabase/CDatabase and CDaoRecordset/CRecordset, but was wondering if there are any ODBC equivalents to the DAO CDaoTableDef and related classes? When opening a database, my apps always check that the database's schema is complete and up to date. The apps create any new tables/fields that are required before proceeding. I'd like to be able to do the same thing with the ODBC version, but the only obvious solution I see is sending raw SQL to the data source via the ODBC API. This is OK, but I was wondering if any of you ODBC gurus out there have a more elegant solution. Actually, in an ideal world, I'd like my apps to support both DAO (speedy single-user performance) and ODBC (multi-user client/server), but I guess that's too much to hope for. Any advice would be appreciated. TIA Steve
-
G'day, I'm thinking of porting one of our apps from DAO to ODBC for database access. I understand the correlation between CDaoDatabase/CDatabase and CDaoRecordset/CRecordset, but was wondering if there are any ODBC equivalents to the DAO CDaoTableDef and related classes? When opening a database, my apps always check that the database's schema is complete and up to date. The apps create any new tables/fields that are required before proceeding. I'd like to be able to do the same thing with the ODBC version, but the only obvious solution I see is sending raw SQL to the data source via the ODBC API. This is OK, but I was wondering if any of you ODBC gurus out there have a more elegant solution. Actually, in an ideal world, I'd like my apps to support both DAO (speedy single-user performance) and ODBC (multi-user client/server), but I guess that's too much to hope for. Any advice would be appreciated. TIA Steve
-
Hi, Use ATL's OLE DB Provider, Consumer Templates. This will satisfy all yr requirements. Or use OLEDB MFC class instead. These stuffs r esay to use and also gives fast and reliable services than that of other MFC stuffs.
Thanks for that Mathan. I was browsing the MSDN help & MS web sites last night and ended up printing off a zillion topics on DB access. I'm just puring my way through the pros and cons of the various options today. I'll check out the OLEDB stuff later. Thanks again, Steve -------------------------------------- Steve Driessens