I am absolutely new to DTS and here is my problem: my DTS (in VB) which I load from storage file works OK on my server. I run the set up on another machine and it seems to work fine, doesn't give me any error massages but it also doesn't make any update of a database. (This machine has VB and SQL server installed.)
Another mashine which doesn't have any of these installed gives me next error: "ActiveX component can't create object"
Do you have any idea what I have to do to make it work. Thanks
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yes.
Executing DTS in a remote server ->
Create a Job on the Remote Server to run the DTS package on the local server for the DTS package.
In VB. Send the start job T-SQL command via ODBC connection information or by isql/osql (command line utilities - reside on sql server)
Job then runs on remote server, local to the server.
d.
It's time to clean up this topic area and that means taking care of this question. Your options at this point are:
1. Award points to the Expert who provided an answer, or who helped you most. Do this by clicking on the "Accept Comment as Answer" button that lies above and to the right of the appropriate expert's name.
2. PAQ the question because the information might be useful to others, but was not useful to you. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.
3. Delete the question because it is of no value to you or to anyone else. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.
If you elect for option 2 or 3, all you need to do is post right here as a comment, and I will take care of the rest. We also request that you review any other open questions you might have and deal with them as necessary.
PLEASE DO NOT AWARD THE POINTS TO ME.
__________________________
Hi Experts:
In the event that the Asker does not respond, I would very much appreciate your opinions as to which Expert ought to receive points (if any) as a result of this question. Likewise, you can also suggest that I PAQ or delete the question.
Experts, please do not add further "answer" information to this question. I will be back in about one week to finalize this question.
Thank you everyone.
Moondancer
Community Support Moderator @ Experts Exchange
P.S. Older questions from last year have comment order errors, they're not in date/time sequence. Engineering has been advised.
Business Accounts
Answer for Membership
by: mick2000Posted on 2000-09-19 at 04:00:06ID: 4353612
The error: "ActiveX component can't create object" is normally to do with registry settings. There is a dll involved that needs to be re-registered. Reinstall the program may help.
It may actually be a built in limitation of VBA. While VBA allows you to create references to RDO on a development machine that has VB or C++ installed, it actually doesn't allow it to distribute this solution to a customer that does not have these tools installed. If VB or Visual C++ is installed (as in the situation above), it may work on the end user's machine but this solution isn't supported by MS. MS suggests using ODBCDirect & DAO to access the data. The link below connects to a MS Technical document that discusses this problem.
http://support.microsoft.c
Hope this helps you