RDO working on development PC, not on deployment PC

[dman]

Hi.

Perhaps someone can help me determine what I'm missing here. This little
bit of VBA code works on machines that have VB6 installed on them. When
I take the spreadsheet to another machine is when it fails.

When I debug and mouse over rdoEngine.rdoEnvironments(0)...it says Object
var
or with block var no set. Does early binding(selecting references) not work?

Private Function OpenDataBase(ByVal Userid As String, ByVal Password As
String) As Boolean
On Error GoTo err_routine
Set gcnXXXEnv = rdoEngine.rdoEnvironments(0)
<more removed>
err_routine:
OpenDataBase = False
End Function

Thanks!

 

[Sam Wilson]

Go to tools/references and add "Microsoft Remote Objects 2.0" or similar

 

[dman]

I do have that reference selected and the DLL exists.

It seems like the rdoEnvironment can be created, but not the rdoEngine.

In my module I have: Public gcnXXXEnv As rdoEnvironment

That seems to be instanced just fine. When I mouse over it in my function,
it is equal to nothing.

Can you think of any other things for me to try? (fyi I am using excel 2003)

 

[dman]

I am going to remove all the RDO code and use ADO. That seems to
work.

Thanks.