当我尝试使用SQLDMO获取服务器列表时，它给出了错误＃429 [英] It gives me error# 429 when I try to get servers list using SQLDMO

问题描述

i有一个用vb6 sp6编写的大应用程序，我是支持者。

i知道它是一个过时的版本，但实际上它是一个非常好的应用程序。

i有一个书面函数来使用SQLDMO获取服务器列表

以下是代码：

Dim Names as SQLDMO.NameList

将SQLApp调暗为SQLDMO.Application

设置SQLApp =新SQLDMO.Application



set Names = SQLApp.ListAvailableSQLServers



然后它给我错误代码429ActiveX组件无法创建对象



你有没有任何建议可能是错误



我尝试过：



i尝试注册SQLDMO.dll但没有运气

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

推荐答案

通常，这意味着缺少SQLDMO库使用的.DLL。它可能不是SQLDMO .DLL。它可能是它对另一个库的依赖。



另一种可能性是.DLL在那里，但它们可以是基于COM的，而不是在机器上注册。 br />


代码是什么样的抛出错误？不是整个应用程序，只是抛出的片段以及扔掉它的行。

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.

这篇关于当我尝试使用SQLDMO获取服务器列表时，它给出了错误＃429的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！