Activex Component cannot ...

[Kaushik1975]

Hello
I have installed VB. Tool reference of the ADO 2.0, but when i create a object of that i get a erro

"Activex Component cannot create object"

What is the solution to this

 

[woyler]

Can you post your code?

 

[Kaushik1975]

Dim Conn as Adodb.Connection

Private Sub Form_Load()
set conn = new Adodb.Connection 'I get the error here
End Sub

 

[woyler]

Do you have the reference to ADO 2.0 selected? Open the project, and from your menu go to Projects, References and verify that Microsoft Active X Data Objects 2.x Library is checked.

 

[MikeCox]

Try this:

Set conn = CreateObject("ADODB.Connection&quot

Either should work, but this is another way of doing it if you wanna try it.

-Mike

 

[IonelBurtan]

Try to regsvr32 the ado library usually msado15.dll.
Maybe is not registered well.

(If this happens in a asp page is usually a security problem)

-
s-)

Blessed is he who in the name of justice and good will, shepards the week through the valley of darkness...

http://www20.brinkster.com/ionelb

 

[Kaushik1975]

I do not have msado15.dll on my machine, i have msado15.tlb which is ADODB 2.0. How do u register a tlb file

 

[JohnYingling]

The .TLB is what keeps you from getting a copmpile error on
Dim Conn as Adodb.Connection.
The .TLB has all the names and vTable offsets that are needed to compile but not having the DLL registered, or not having it at all is what is giving you the "Can't create object". The TLB (Type Library ) is useful only at compile time.

What you have is the equivalent of having the "Word" .OLB lib without having Word on registered on your machine.

http://WWW.VBCompare.Com