OLE DB/ATL guides worthless
-
For the last month i have studing OLE DB with ATL and the ATL wizard in Visual studio c++. I have Read severals articles about connecting to a database with CCommand and Caccessor and making SQL questions under DEFINE_COMMAND...... All this articles reflects a DB with only one Table. When you then wont to connect to several tables making SQL question, how do i do that? Is it not possible or what? It must be, or else i think the ATL class for OLE DB is useless. /Bigge
-
For the last month i have studing OLE DB with ATL and the ATL wizard in Visual studio c++. I have Read severals articles about connecting to a database with CCommand and Caccessor and making SQL questions under DEFINE_COMMAND...... All this articles reflects a DB with only one Table. When you then wont to connect to several tables making SQL question, how do i do that? Is it not possible or what? It must be, or else i think the ATL class for OLE DB is useless. /Bigge
Just like with anything the wizards are a good start, but you must be able to add to what has been provided. The ATL OLE DB wizard only works with one table soyou will have to hand code the Accessor to provide for the additional tables.