Re: Ado 2.6
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 9 Feb 2006 10:38:03 -0000
I hope your CreateObject is a typo, because you've missed the quotes out.
Assuming it's not ...
If you have a reference to the tlb, use this
Set oRec = New ADODB.Recordset
if you are using late binding, use this
Set oRec = CreateObject("ADODB.Recordset")
Dan
sparvathi123@xxxxxxxxx wrote on 8 Feb 2006 15:03:58 -0800:
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
.
- References:
- Ado 2.6
- From: sparvathi123
- Re: Ado 2.6
- From: Richard Mueller
- Re: Ado 2.6
- From: sparvathi123
- Ado 2.6
- Prev by Date: [Newbie] ADOBV versions
- Next by Date: RE: Datarelations with a single table
- Previous by thread: Re: Ado 2.6
- Next by thread: Re: When to Update() a database from datagridview
- Index(es):
Relevant Pages
|
|
