Re: ADOX set-up



Pontus,

Did you get anywhere with this?

I am looking into this for my D2005 setup. Hit the same snags you did.

....Andy
Pontus Berg wrote:
Many thanks Mike,

I must stress that you are still pointing in a direction which makes it impossible for me follow as the 2006 IDE is what I have in front of me.

I would imagine that you start by doing:

"Component" -> "Import Component" and selecting "Import a Type Library"

I pick "Microsoft ADO Ext. 2.8 for DLL and Security (2.x)"

It's now I get lost; there is no way to rename any of the Class Names - they are visible, but greyed out.

... and this is where I am lost! A unit is show with 3300 lines of code which is the djungle I am in when the compass broke down ...

/Pontus

mIKE skrev:
Pontus:

Here's a slighly enhanced version of the message I posted here on January 3, 2006. Though I was using Delphi 5, you might find some of it useful.

I've seen a lot of messages about using ADOX with Delphi 5, and since I had
trouble resolving the differences between the conflicting information I've
encountered, I thought I'd present what seems to have worked for me and ask
for corrections. I've searched the web using clues like these: ADOX INSTALL
ADOX TYPELIB

To install the type library into the D5 IDE:

Project | Import Type Library

then select: Microsoft ADO Ext. 2.x for DLL and Security (2.x)

Change the object names from their defaults to these

(note that, contrary to lots of info on the web,
TKey and TCatalog do not get changed.

Specifically, the info at this link:

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

is wrong about these 2 items, IMO.)


ADOXTable

TADOXColumn

TADOXIndex

TKey

TADOXGroup

TADOXUser

TCatalog


Click Install

Select the tab for Install into new package and provide the following:

Filename: c:\program files\borland\delphi5\Lib\adox.dpk

Description: ADOX ADO extensions (or whatever you like)

Click OK

You'll get the confirmation dialog:

Package adox.bpl will be built then installed. Continue?


Click Yes.

Close the window whose title is "Package - adox.dpk"


You'll get a confirmation dialog:

Save changes to project adox?


I don't know if it makes any difference if you save the changes, but I do it
anyway.

Then I make sure to include ADOX_TLB in my Uses clause.

Anybody care to correct, clarify, or embellish?

mIKE




.



Relevant Pages

  • Re: ADOX set-up
    ... Though I was using Delphi 5, you might find some of it useful. ... I've searched the web using clues like these: ADOX INSTALL ... Package adox.bpl will be built then installed. ...
    (borland.public.delphi.database.ado)
  • ADOX in D5 - success
    ... I've searched the web using clues like these: ADOX INSTALL ... You'll get the confirmation dialog: ... Package adox.bpl will be built then installed. ...
    (borland.public.delphi.database.ado)
  • Re: managing References
    ... yes, ADOX is bit tricky, you should use exact version number you installed. ... so you either have to install same ADO version on all PCs, ... > - Microsoft ADO Ext. 2.7 for DDl and Security. ... Why I see on my system Microsoft ADO Ext. 2.7 for DDl and Security ...
    (microsoft.public.access.modulesdaovba)
  • Errors applying kernel patch 118833-36
    ... install of Solaris 10 11/06. ... However, once the package list is done, I see a worrisome message: ... Below is the complete console output of the patch run. ... Changes for package SUNWnfsskr will not be applied to the system. ...
    (SunManagers)
  • Re: media player 10 setup issues
    ... Finished building install list. ... Package 'MPPRE' is version '10.0.0.3802'. ... Install for Exception pack ...
    (microsoft.public.windowsmedia)