Need generic (database transparent) create-table functionality. What's better DDL or ADOX? 
Author Message
 Need generic (database transparent) create-table functionality. What's better DDL or ADOX?

I am creating a component that will create tables in a database. The
database could be SQL Server (6.5 or 7) Oracle, or Informix. It will need to
define table's name, fields' names and types, and indexes - nothing more.

Is ADOX the right tool, or should I use DDL (Data Definition Language?) and
pass it as text to the db engine?

What are some good ADOX or DDL resources?

Thanks for the help,

Josh



Tue, 08 Oct 2002 03:00:00 GMT  
 Need generic (database transparent) create-table functionality. What's better DDL or ADOX?
 In theory ADOX should hide you from DDL changes between dbms's but where (other than the MSDN site) you can get
more in fo on it I don't know...

 > I am creating a component that will create tables in a database. The

Quote:
> database could be SQL Server (6.5 or 7) Oracle, or Informix. It will need to
> define table's name, fields' names and types, and indexes - nothing more.

> Is ADOX the right tool, or should I use DDL (Data Definition Language?) and
> pass it as text to the db engine?

> What are some good ADOX or DDL resources?

> Thanks for the help,

> Josh

 Neil Pike MVP/MCSE.  Protech Computing Ltd
 (Please reply only to newsgroups)
 SQL FAQ (428 entries) see
 forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps (sqlfaq.zip - L7 - SQL Public)
 or www.ntfaq.com/sql.html
 or www.sql-server.co.uk
 or www.mssqlserver.com/faq


Sat, 12 Oct 2002 03:00:00 GMT  
 Need generic (database transparent) create-table functionality. What's better DDL or ADOX?
Hi,

Use DDL the best way to do a hetwrogenus solution is to store the
definition in metadata and then generate it for a certain environmen if
you do not want to do this yourself you could use a tool such as
Computer Associates ER/Win. Another way to do it is to use
a "precompiller" such as C/C++ compiler to separate different
environments with #ifdef ORACLE8 ... #ifdef SQL7 ... This way you
script your ddl scripts automatically.

About ADOX; this information is from the ADOX readme and might have
changed with the release of MDAC 2.6 (The one included in SQL Server
2000).

Using ADOX with Microsoft OLE DB Providers

Certain features of ADOX are unsupported, depending upon your OLE DB
data
provider. ADOX is fully supported with the OLE DB Provider for Microsoft
Jet. The unsupported features with the Microsoft OLE DB Provider for SQL
Server, the Microsoft OLE DB Provider for ODBC, or the Microsoft OLE DB
Provider for Oracle are listed below. ADOX is not supported by any other
Microsoft OLE DB providers.

1.      Microsoft OLE DB Provider for SQL Server   All ADOX objects,
collections, properties, and methods are supported except for those
listed
here:
Catalog: Create method.
Tables: Properties for existing tables are read-only (properties for new
tables can be read/write).
Views: Not supported.
Procedures: Append method, Delete method, Command property.
Keys: Append method, Delete method.
Users: Not supported.
Groups: Not supported.

2.      Microsoft OLE DB Provider for ODBC   All ADOX objects,
collections,
properties, and methods are supported except for those listed here:
Catalog: Create method.
Tables: Append method, Delete method. Properties for existing tables are
read-only (properties for new tables can be read/write).
Views: Append method, Delete method, Command property.
Procedures: Append method, Delete method, Command property.
Indexes: Append method, Delete method.
Keys: Append method, Delete method.
Users: Not supported.
Groups: Not supported.

3.      Microsoft OLE DB Provider for Oracle   All ADOX objects,
collections, properties, and methods are supported except for those
listed
here:
Catalog: Create method.
Tables: Append method, Delete method. Properties for existing tables are
read-only (properties for new tables can be read/write).
Views: Append method, Delete method, Command property.
Procedures: Append method, Delete method, Command property.
Indexes: Append method, Delete method.
Keys: Append method, Delete method.
Users: Not supported.
Groups: Not supported.



Quote:
> I am creating a component that will create tables in a database. The
> database could be SQL Server (6.5 or 7) Oracle, or Informix. It will
need to
> define table's name, fields' names and types, and indexes - nothing
more.

> Is ADOX the right tool, or should I use DDL (Data Definition
Language?) and
> pass it as text to the db engine?

> What are some good ADOX or DDL resources?

> Thanks for the help,

> Josh

--

Quote:
> Help the needing:
> http://www.hungersite.com/
> http://rainforest.care2.com/front.html/7730d1620ebab18d

Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 20 Oct 2002 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Need generic (database transparent) create-table functionality. What's better DDL or ADOX?

2. Creating database's an tables

3. Creating database's an tables

4. Q: need C's vprintf functionality

5. HELP: Need help in creating a table from a table within Access

6. I can't create a transparent label (createwindowex)

7. Can't create an StaticControl transparent (CreateWindowsEx)

8. Q: ADO, 'CREATE TABLE' and TYPE_NAME

9. Database Tables Disappearing - HELP HELP - Need Access Database specs

10. Buy Generic cialis Online Sherbrooke order cialis no prescription Buy Generic cialis Online Arizona generic cialis information online in Canada no prescription order cialis online buy reduce priced generic cialis

11. Can't see a database table's attributes

12. 'Creating' Databases in VB4

 

 
Powered by phpBB® Forum Software