-
I'm supposed to debug an App made by some other dude, and when I try to run it, this is what I get:
----------------------
Run-time error '429':
ActiveX component can't create object
----------------------
When I hit the 'Debug' button, the first line of this code is "yellowed"...
With rdoEngine
.rdoDefaultLoginTimeout = 20
.rdoDefaultCursorDriver = rdUseOdbc
End With
Anybody have a clue? Any tips?
Could it be that I haven't installed some DB drivers, and/or set ODBC or something up correctly?
Everything counts...
-
rdoEngine , what does it stand for ??
I think you haven't got the OCX registered for this control.
Good luck
-
Rdo is a Remote Data Source/Object
This is what MSDN says:)
-------------------------------------------
Dim en As rdoEnvironment
Private Sub Form_Load()
With rdoEngine
.rdoDefaultLoginTimeout = 20
.rdoDefaultCursorDriver = rdUseOdbc
.rdoDefaultUser = "Fred"
.rdoDefaultPassword = ""
End With
Set en = rdoEnvironments(0)
'
' Dump current rdoEnvironments collection
' and display current properties where
' possible.
'
For Each en In rdoEnvironments
Debug.Print "LoginTimeout:" & en.LoginTimeout
Debug.Print "CursorDriver:" & en.CursorDriver
Debug.Print "User:" & en.UserName
' (Write-only) Debug.Print "Password:" & en.Password
Next
End Sub
------------------------
Shouldn't the "RdoEngine" object be defined somewhere?
If it is defined in ODBC setup, where do I tell vb which Rdo source to look for?
Thnx...
-
I think so too, like you've said.
set "en" equal to the engines environments and fil up "en".
Dim en As rdoEnvironment
Set en = rdoEngine.rdoEvironments(0)
With en
en.CursorDriver = rdUseOdbc
en.LoginTimeout = 20
en.Name = "TransOp1"
End With
-
It could be possible that you have not referenced this object yet. If this is so, Choos Project from the menu and click on the References... then select Microsoft Remote Data Object 2.0 ...
Hope this helps.
-
I've checked Microsoft Remote Data Object 2.1
But as it says "ActiveX component can't create object", which ActiveX component are we talking about here?
Damn this problm!
-
Is this a common problem?
I had the same probleme once.
Anybody experienced with RDO out there?
