
Using ADO to create/delete tables & fields
Hi LuAnn,
I am struggling with the same problem. Here's what I've learned. ADO is an
OLE DB interface, but you already knew that. It was developed specifically
for the automation clients -- VB, VBA, Script, etc. Since C++ is not really
an automation client, ADO has little use.
I haven't yet tried, but I will, creating an ADODB.Recordset in C++ and
dealing with the IDispatch interface. I don't know any reason why this
shouldn't be possible.
Alternatively, the OLE DB custom interfaces are available. I don't yet know
anything about these. But I fear I will soon. :')
I don't think there is any reason that you can't mix them, but I'm guessing.
Maybe someone with greater experience will jump in and correct my
misapprehensions.
Chris.
Quote:
>Can I create/delete tables and fields within a database using ADO? Is it
>possible to use the EXECUTE method and specify the creation information
>in an SQL statement passed to the EXECUTE method?
>Can I mix ADO and OLE DB in the same C++ application to access the same
>database?
>Thanks for the help!
>LuAnn