It gives me error# 429 when I try to get servers list using SQLDMO

Question

1.00/5 (1 vote)

See more:

Hi,
i have a big application written in vb6 sp6, and i am the support guy.
i know it's an obsolete version but really it's a very good application.
i have a written function to get the servers list by using the SQLDMO
following is the code:
Dim Names As SQLDMO.NameList
Dim SQLApp as SQLDMO.Application
Set SQLApp = New SQLDMO.Application

set Names = SQLApp.ListAvailableSQLServers

then it gives me error code 429 "ActiveX component can't create object"

do you have any suggestions what could be the error

What I have tried:

i tried to register the SQLDMO.dll with no luck

Posted 4-Mar-19 12:34pm

aelkatatny@eg

Updated 4-Mar-19 12:51pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2019-03-04T12:52:00

Solution 1

Usually, that means a .DLL that is used by the SQLDMO library is missing. It may not be an SQLDMO .DLL. It could be a dependency it has on another library.

Another possibility is the .DLL's are there but they could be COM-based and not registered on the machine.

What does the code look like that is throwing the error? Not the entire application, just the snippet that's throwing and what line is throwing it.

Posted 4-Mar-19 12:52pm

Dave Kreskowiak

Comments

aelkatatny@eg 5-Mar-19 9:24am

thanks Dave,
but how could i know the missing dependency or the COM which is not registered

Dave Kreskowiak 5-Mar-19 10:47am

Well, first, SQLDMO has been deprecated since SQL Server 2008. You can still get SQLDMO from https://www.microsoft.com/en-us/download/details.aspx?id=17943.

It's a collection of stand alone installers. For the life of me, I can't remember which on of those installers has DMO in it.

You're going to have to test each one to figure out which has DMO in it. It's not as bad as the size of the list would suggest. You can only use the 32-bit installers, which are the ones that don't end in "ia64" or "x64".

aelkatatny@eg 5-Mar-19 10:59am

thanks again Dave,
but the link you shared is for SQL server 2005, and i am using SQL Server 2008.
and on my development machine the program works fine,
but when i build it and try to deploy it on another machine, first it give me an error "Module .dll Failed to register HRESULT -2147024714.
when i try to re-register this DLL it gives me the following error:
the module "c:\program" failed to load
make sure the binary is stored at the specified path or debug it to check for problems with binary or dependent dll
the specified module could not be found.

Dave Kreskowiak 5-Mar-19 11:05am

It's not "FOR sql server 2005". The components you're looking for are separate from SQL Server and are not version dependent. It's just that the last version of SQL Server to come with the components was 2005.

Whatever "module.dll" is, I have no idea. It seems like something your wrote in your app.

The "C:\Program" thing is because you executed some command but did not wrap the entire path string in " characters. Every path that has spaces in it must be enclosed in double quote characters:

"C:\Program Files\Some Folder\Some File.dll"

aelkatatny@eg 5-Mar-19 11:13am

i will check something and get back to you bro.
thanks in advance.

aelkatatny@eg 5-Mar-19 16:21pm

thanks a lot Dave.
it works fine now after i re-register 2 DLLs after i run regsvr32 in cmd when i run it as administrator.
but, i have another question, if you can help me.
how to make sure that these DLLs will be successfully registered when i deploy my app.?
as i told you the app. is written in VB6.
and i use the setup & Deployment project in Visual Studio 2008 for the setup project to make the install .msi & .exe files.
do you have any suggestions?
and thanks again brother.

Dave Kreskowiak 5-Mar-19 19:02pm

I found that Setup and Deployment project a bit ... lacking. I never got into using it. Since I have to use InstallShield at work, that's what I use all the time.

In InstallShield, it's easy. Open the component holding the .DLL you want to register and click on it's Files branch. You then right-click the file, click Properties, and click a little checkbox that says "COM Self-Register". Done.

Or, another way to do it is to just use the COM import wizard and Installshield will extract the registration information and dump all that into the registry for you.

aelkatatny@eg 6-Mar-19 2:09am

thanks a lot Bro.
may i ask for your assistance to tell me how to use installshield.
as i found it little bit complicated.

Dave Kreskowiak 6-Mar-19 8:16am

That is way too much information to put into a few posts.

https://helpnet.flexerasoftware.com/installshield21helplib/helplibrary/TutorialTop.htm?

aelkatatny@eg 6-Mar-19 17:44pm

Thanks Dave,
i will check this tutorial and if i have any problems i will contact you bro.