Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

moving visual basic program to window server 2003

Posted on 2013-01-14
7
Medium Priority
?
474 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 58
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 46

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 58
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
Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

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 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1500 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

636 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