rdo data connection problem

I am using the following code to establish a rdo db connection .....

Global grdxConn As New rdoConnection

Sub InitializeDB()

Dim lstrConnect As String

rdoEngine.rdoDefaultCursorDriver = rdUseOdbc
   
'DSN Less connection
lstrConnect = "UID=;PWD=;" _
            & "Driver={Microsoft Access Driver (*.mdb)};" _
            & "DBQ=C:\Leica\sap-migration\sutosap.mdb;" _
            & "DSN=;"
                   
grdxConn.Connect = lstrConnect
grdxConn.EstablishConnection

Exit Sub

...this works on my machine (win95), but not on another win95 machine, ..I get the following error on the first line (rdoEngine.rdoDefaultCursorDriver = rdUseOdbc) ...

"ActiveX component cannot create control" (error number 429)

...I've checked the dll versions for any rdo associated dlls, and they're the same on both machines, ...can anyone help ?
gbrAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
cymbolicConnect With a Mentor Commented:
Could be a problem in registration of the .dlls.  Just because they are copied over to the other machine, doesn't mean the system will find them.  Either they had to make their way there through an install wizard/setup, which registers them, or through installation of something like VB Enterprise Edition, or they have to be manually registered with RegSvr.
0
 
vdevaraoCommented:
Hi
 I was also having the samoe problem with RDO. The RDO connection works fine on my machine, but when i run the same application on another machine which doesn't ahve vb i get a runtime error 429; ActiveX Cant' create object..

Can one please tell why i get this error with RDO.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.