Solved

Using RDO

Posted on 1999-01-17
8
853 Views
Last Modified: 2013-12-25
I am trying connecting to a DB using RDO, but everytime I try set the connection variable I get err# 429 (ActiveX component can't create object or return reference to this object)

'dim RDOcon as rdoconnection
'set RDOcon = new rdoconnection (<=== error happens here)

Using RDO shouldn't be that a problem, should it ?

by the way: I have checked if RDO is registered in the registry correctly

If you have got the solution I would very much like to hear it!





0
Comment
Question by:in
[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
8 Comments
 
LVL 3

Expert Comment

by:vbWhiz
ID: 1499122
You could try something a bit more like this to see if it works - I don't understand why you would be getting that error though?


Dim rdoEnv As rdoEnvironment
Dim rdoCon As rdoConnection

Set rdoEnv = rdoEnvironments(0)
Set rdoCon = rdoEnv.OpenConnection(dsName:="", Prompt:=rdDriverNoPrompt, Connect:="uid=;pwd=;driver={SQL Server};server=SEQUEL;database=pubs;")

0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 1499123
Which version of RDO do you use? I have tried your declaration with RDO 1.0 which gives another error messages (invalid use of New keyword). With RDO, all seems to be right. With no references, I obtain a user-defined type mot defined.

The normal way of setting a connection is like vbWhiz show you.
0
 

Expert Comment

by:kianwei
ID: 1499124
Have u checked the entry in the Projects/Preference in order to use
the RDO object ?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:in
ID: 1499125
I have tried the code vbWhiz put in, but I still get the err# 429

'Dim rdoEnv As rdoEnvironment
'Dim rdoCon As rdoConnection

'Set rdoEnv = rdoEnvironments(0) <=== ERROR HAPPENS HERE
'Set rdoCon = rdoEnv.OpenConnection(dsName:="", 'Prompt:=rdDriverNoPrompt, Connect:="uid=;pwd=;driver={SQL 'Server};server=SEQUEL;database=pubs;")

It seems VB has a problem with setting any RDO-related object variable...

by the way: the reference to RDO has been set!
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 1499126
Again, which version of RDO do you use?

Which version of VB5 do you use? Professional or Enterprise? RDO only come with the Enterprise edition. So maybe you have an RDO DLL that was installed by a software but no license to create run-time instance.
0
 
LVL 1

Accepted Solution

by:
twolff earned 300 total points
ID: 1499127
I would suggest downloading MDAC 2.0 from Microsoft. It is the lastest version of all of the data objects. You can download MDAC from Microsoft at this URL: http://www.microsoft.com/data/download.htm

I have had similar problems at runtime and this fixed the problem. RDO uses multiple libraries and evidentally one of them is not registered correctly. You can download the typical(small) or the SDK(Full with help).
Hope this helps. Enjoy.
0
 

Expert Comment

by:CS011999
ID: 1499128
Did you make the Reference to RDO's type library?
i.e : go to menu Project-References & check the box for RDO (MS Remote Data Object 2.0)
0
 

Expert Comment

by:vdevarao
ID: 10551103
Hi I had the same problem with RDO

Dim cn As rdoConnection
Set cn = New rdoConnection (i get error here Err 429 ActiveX Can't Create Object).

I referenced RDO2.0 Object Library, i even Installed MDAC2.7 just now. I'm using VB6.0 professional edition.

I even tried :

'Dim rdoEnv As rdoEnvironment
'Dim rdoCon As rdoConnection

'Set rdoEnv = rdoEnvironments(0) <=== ERROR HAPPENS HERE
'Set rdoCon = rdoEnv.OpenConnection(dsName:="", 'Prompt:=rdDriverNoPrompt, Connect:="uid=;pwd=;driver={SQL 'Server};server=SEQUEL;database=pubs;")

Can some one please tell why i get this error with VB6.0. Doesn't VB6.0 support RDO?

Your help is greatly appreciated
0

Featured Post

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
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…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month9 days, 9 hours left to enroll

624 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