[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

rdo data connection problem

Posted on 1998-07-02
2
Medium Priority
?
775 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 60 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…
Suggested Courses

650 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