Re: Ado 2.6

The reference is showing up in VB which refers to msad026.tlb. But when
I run it, CreateObject(ADODB.Recordset) throws automation error.

Richard Mueller wrote:
Parvathi wrote:

I am working on a VB component which uses ADODB.Recordset. Even though
ADO 2.6 and MDAC 2.6 are installed in the machine, the registry
doesn't have any class name for ADODB.Recordset. Hence the Recordset
creation fails. If anyone have faced similar problem and know a
solution please email me. Thanks in advance.

Note: I have .NET also installed in my machine.

Hi,

If MDAC is installed you should be fine. If your are using VB or VB.NET you
probably need to add a reference to "Microsoft ActiveX Data Objects 2.6
Library", which refers to msado26.tlb. In .NET I believe it is on the "COM"
tab when you add references. When you expand references in Solution Explorer
you should see ADODB. In VBScript you don't need any references.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

.

Relevant Pages

  • Re: Ado 2.6
    ... If MDAC is installed you should be fine. ... probably need to add a reference to "Microsoft ActiveX Data Objects 2.6 ... When you expand references in Solution Explorer ...
    (microsoft.public.data.ado)
  • Re: Count Intervals of 2 Numeric values in same Row and Return Count across Row
    ... In the interest of making the formula for B2 shorter and somewhat ... >But for some reason I get error messages for the second interval and ... I defined both LARGE Function references as suggested using their respective ... LARGE syntax in the Names Refers To Box and used the shorter Defined Names in ...
    (microsoft.public.excel.worksheet.functions)
  • Re: possible bug: excel "names" conflict
    ... Nope, all references are absolute. ... The cell ref itself doesn't change, ... it's the worksheet reference that gets "doubled" I'm pretty sure ... refers to Second!$A$1:$A$10 ...
    (microsoft.public.mac.office.excel)
  • Re: better understanding references
    ... >> location in memory containing the value being passed. ... you understand references in general. ... b is another name for a, or b _refers_ to a. ...
    (alt.comp.lang.learn.c-cpp)
  • Re: Passing hashes to a function
    ... you are only copying the overall hash. ... you are copying the ... you are copying the references. ... You are here modifying the value that $aarefers to. ...
    (comp.lang.perl.misc)