Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

deploy application with sqldom

Posted on 2003-03-20
4
Medium Priority
?
409 Views
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 ?

/shammie
0
Comment
Question by:shammie
  • 2
4 Comments
 
LVL 34

Expert Comment

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

Brett
0
 
LVL 34

Accepted Solution

by:
arbert earned 225 total points
ID: 8183113
0
 

Author Comment

by:shammie
ID: 8192904
thanks for your time.

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

/shammie
0
 

Expert Comment

by:CleanupPing
ID: 9275669
shammie:
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 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

579 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