Solved

rdo data connection problem

Posted on 1998-07-02
2
747 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 30 total points
ID: 1464867
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
ID: 10608020
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MsgBox 2 61
How to make an ADE file by code? 11 99
all the possible sequences for numbers 1,2,3,4,5,6,7,8,9,10 in groups of 5. 5 42
VB script to continue despite error 2 51
Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

756 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