Solved

moving visual basic program to window server 2003

Posted on 2013-01-14
7
458 Views
Last Modified: 2013-02-01
moving a vb application to window server 2003.  Installed visual studio 6 on the window server 2003 so it have the same references as on my workstation.  When it runs, it fails because "ActiveX Component can't create object   RunTime Error '429'
The problem is in the DTS.package code - it fails at the last statement "Set goPackage = goPackageOld "
---------------------------------------------------------------------------------------
Option Explicit
Public goPackageOld As New DTS.Package
Public goPackage As DTS.Package2
Public Sub datapump()
        MsgBox "datapump started1"
        Set goPackage = goPackageOld
0
Comment
Question by:phiadmin
[X]
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
  • 3
  • 3
7 Comments
 
LVL 57
ID: 38778115
Need to check the references.   Just because you installed VB6 doesn't mean you have all the DLLs or type libs that a project may reference as they may be from other installs and products (such as SQL Server).

If you set a specific reference, it's expecting the reference to be the same version and it being in the same place as it was before.

Jim.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 38778411
does it matter that one of these variables is a DTS.Package and the other is a DTS.Package2 ?
0
 
LVL 57
ID: 38778743
<<does it matter that one of these variables is a DTS.Package and the other is a DTS.Package2 ? >>

 Looks like they either had two references set or maybe two different class wrappers written for one DTS package.

 Don't think that's a mistake, but without seeing the rest of the code, it's hard to say if it is or not.

 Still sounds like a reference problem though in anycase...

Jim.
0
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

Author Comment

by:phiadmin
ID: 38779164
I am not an expert on vb, just trying to maintain this process until it is replace by a new ERP.

The program works on my workstation so I should not have to change the code.

The 7 references are the same on both system
The Microsoft DTSPackage Object Library reference the same DTSPKG.dll
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 38779698
<<The 7 references are the same on both system
The Microsoft DTSPackage Object Library reference the same DTSPKG.dll >>

 Do the references include DAO?  If so:

1. Uncheck the reference in the VB6 program and close it
2. Drop to a command prompt and un-register it:

regsvr32 -u "c:\program files\common files\microsoft shared\dao\dao360.dll"

3. Re-register it:

regsvr32 "c:\program files\common files\microsoft shared\dao\dao360.dll"

4. Open the VB6 program, select the reference and check it, then try it.

If you don't have a reference for DAO, then one of the other references is broken.  It will be one of the ones before the DTS reference.  You'll have to investigate each one.   It needs to be in the same location and the same version as the one where the program works.

 If you still stuck, paste a screen shot of the references.

Jim.
0
 

Author Comment

by:phiadmin
ID: 38811159
We are going to install sqlServer on the server to test if that will fix the problem
0
 

Author Comment

by:phiadmin
ID: 38845484
after installing SQL SERVER, the vb code ran ok
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

730 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