Author Topic: Availability of ADODB.Command  (Read 2980 times)

0 Members and 1 Guest are viewing this topic.

Kerry

  • Mesozoic relic
  • Seagull
  • Posts: 11654
  • class keyThumper<T>:ILazy<T>
Availability of ADODB.Command
« on: November 27, 2006, 07:08:12 PM »
I want to determine if the code following works if MS Office is not installed.
I'm particularly interested in ADO COM at this time.
In an XP install I believe MDAC is installed which I think should satisfy this test ..

If my assumption is whacky, I'll have to try another route.

This code just does Registry reads ...
... please post results

Code: [Select]
(DEFUN c:test ()
    (AND (SETQ _ADODLLCLSID (VL-REGISTRY-READ
                                "HKEY_CLASSES_ROOT\\ADODB.Command\\CLSID"
                            )
         )
         (SETQ
             _ADODLLPath (VL-REGISTRY-READ (STRCAT "HKEY_CLASSES_ROOT\\CLSID\\"
                                                   _ADODLLCLSID
                                                   "\\InProcServer32"
                                           )
                         )
         )
         (SETQ _ADODLLPath_Qualified (FINDFILE _ADODLLPath))
    )
    (TERPRI)
    (princ _ADODLLCLSID)
    (TERPRI)
    (princ _ADODLLPath)
    (TERPRI)
    (princ _ADODLLPath_Qualified)
    
    (princ)
)

Thanks
kwb

kdub, kdub_nz in other timelines.
Perfection is not optional.
Everything will work just as you expect it to, unless your expectations are incorrect.
Discipline: None at all.

LE

  • Guest
Re: Availability of ADODB.Command
« Reply #1 on: November 27, 2006, 07:21:36 PM »
Si funciona Kerry, aqui estan los resultados (aqui no esta instalado nada de Office)

It works Kerry, below are the results (I do not have any Office installed here)

Quote
Command: test

{00000507-0000-0010-8000-00AA006D2EA4}
C:\Program Files\Common Files\System\ado\msado15.dll
C:\Program Files\Common Files\System\ado\msado15.dll

Espero te sirva
HTH

Kerry

  • Mesozoic relic
  • Seagull
  • Posts: 11654
  • class keyThumper<T>:ILazy<T>
Re: Availability of ADODB.Command
« Reply #2 on: November 27, 2006, 07:26:56 PM »
That 'serves me' well Luis, Thanks ....


Would like a couple more confirmations though .... just to be positive.

kwb
kdub, kdub_nz in other timelines.
Perfection is not optional.
Everything will work just as you expect it to, unless your expectations are incorrect.
Discipline: None at all.

T.Willey

  • Needs a day job
  • Posts: 5251
Re: Availability of ADODB.Command
« Reply #3 on: November 27, 2006, 07:28:41 PM »
Mine is the same as Luis's.  But I think I have office installed, I mean I have all the programs.
Tim

I don't want to ' end-up ', I want to ' become '. - Me

Please think about donating if this post helped you.

Kerry

  • Mesozoic relic
  • Seagull
  • Posts: 11654
  • class keyThumper<T>:ILazy<T>
Re: Availability of ADODB.Command
« Reply #4 on: November 28, 2006, 12:06:20 AM »
Anyone else without Office/Access installed in Win XP ??

kdub, kdub_nz in other timelines.
Perfection is not optional.
Everything will work just as you expect it to, unless your expectations are incorrect.
Discipline: None at all.

It's Alive!

  • Retired
  • Needs a day job
  • Posts: 8741
  • AKA Daniel
Re: Availability of ADODB.Command
« Reply #5 on: November 28, 2006, 12:12:53 AM »
Anyone else without Office/Access installed in Win XP ??



I do, but there is no cad on it. Is there something I can look for manually?

edit

the brand new install XP SP2 has the file  C:\Program Files\Common Files\System\ado\msado15.dll
nothing has been installed on the machine but the os.

« Last Edit: November 28, 2006, 12:18:01 AM by Danielm103 »

Kerry

  • Mesozoic relic
  • Seagull
  • Posts: 11654
  • class keyThumper<T>:ILazy<T>
Re: Availability of ADODB.Command
« Reply #6 on: November 28, 2006, 12:30:51 AM »
PERFECT !! Thanks Daniel ..
kdub, kdub_nz in other timelines.
Perfection is not optional.
Everything will work just as you expect it to, unless your expectations are incorrect.
Discipline: None at all.