deploy application with sqldom

Posted on 2003-03-20
Medium Priority
Last Modified: 2007-11-27
I created an application using VB6 (sp5).
There for i have to set the reference to “Microsoft SQLDMO Object Library (.....\sql...\Binn\sqldmo.dll)”

At last I created the Setup and install it into a machine that doesn’t has SQL Server (client or server). It is not working.

The error is
ActiveX component can't create object. (429)

The error is coming from here;
Set m_oSQLServer = New SQLDMO.SQLServer
[variable declare as Private m_oSQLServer As SQLDMO.SQLServer]

If the machine has SQL Server (client or server) this application is perfectly run.

How I deploy my application with SQLDMO ? I have to install SQL Server ?

Question by:shammie
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
LVL 34

Expert Comment

ID: 8183105
YOu need to distribute sqldmo.dll , SQLresld.dll, sqlsvc.dll, and sqlunirl. Make sure all the self-registering dlls get registered.

LVL 34

Accepted Solution

arbert earned 225 total points
ID: 8183113

Author Comment

ID: 8192904
thanks for your time.

sorry, what is the 4th file: "sqlunirl".
what is the name of the file ??


Expert Comment

ID: 9275669
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

743 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