Using ADO to create/delete tables & fields 
Author Message
 Using ADO to create/delete tables & fields

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



Mon, 09 Jul 2001 03:00:00 GMT  
 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



Tue, 10 Jul 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. How to create a new Access database, table, and field using CDaoDatabase, CDasoTableDef

2. Creating Database/Tables using ADO

3. create and drop tables using vc++ADO

4. Tables & Columns Names using ADO

5. Creating tables using ADO / OLE DB.

6. Creating a table from VC++ using stored in Access import/export table specification

7. Help on creating Tables, Fields, Etc...(newbie question)

8. Creating a new field in an exiting table at a certain position

9. ADO Field Append and creating a disconnected recordset

10. ADO & null fields...help

11. Inserting into multiple tables using identity fields

12. ADO & Multiple database table Problem

 

 
Powered by phpBB® Forum Software