Solved

rdo data connection problem

Posted on 1998-07-02
2
724 Views
Last Modified: 2008-02-01
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 ?
0
Comment
Question by:gbr
2 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 30 total points
Comment Utility
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
 

Expert Comment

by:vdevarao
Comment Utility
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

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now