Re: ADOX - Import type library into Delphi 2007

I am anticipating moving as many Delphi 5 apps as possible to D2007 starting
soon, and since most of what I do is ADO with SQL-Server and Access MDB on
the back end, I will need to know the answer to your question too. If I
discover anything, I will let you know. I will also be trying to determine
if ADO/ADOX have become superfluous in D2007 Enterprise due to some other
available technology. (I think I only use ADOX in one utility program that
I use to print table structures.)

In the interim, I looked at the article in that link, and I find that it is
slightly different from what worked for me. The article calls for renaming
two items that for some reason I found I could not rename without creating
some kind of problem. Specifically, I found that I had to leave TKey and
TCatalog with their original name.

mIKE

"Pontus Berg" <pontus@xxxxxxxxxxxxxxxxx> wrote in message
news:482b581d@xxxxxxxxxxxxxxxxxxxxxxxxx
Howdy!

I asked the same question more than two years ago, and give it a new shot
here as I still have got no answers I have been able to use.

I want to modify an Access database at runtime and this takes ADOX (not
only ADO but also ADOX so you can f.ex. access the structure of the data
and not only the data itself).

Importing a type library is very well described at many informative sites.
Take this brilliant example:

http://delphi.about.com/od/database/l/aa072401a.htm

Now; How do I do that in Delphi 2007? It's totally different and renaming
is not one of the options.

/Pontus Berg


.

Relevant Pages

  • Re: Help! How do I create a database?
    ... Relatively new to Delphi, but not to programming in general, I would ... ADOX package from inside my form. ... As stated in the mentioned chapter, ADO Extensions for Data Definition Language and Security is an extension to the ADO objects and programming model. ... ADOX gives developers a rich set of tools for gaining access to the structure, security model, and procedures stored in a database. ...
    (alt.comp.lang.borland-delphi)
  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: refreshing linked tables: NO DAO
    ... Can't be done with ADO, but it is possible with ADOX. ... Dim objFECatalog As ADOX.Catalog ... Dim strTableNm As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)