Wednesday, June 13, 2018

VB6.0 Package and Deployment Wizard Error Unexpected error number 429 has occurred: ActiveX component can't create

a.. When you open the Package and Deployment Wizard, this error message
appears:
  Run-time error '429': 
  ActiveX component can't create object 
  -or-
  b.. After you choose the Package or Deploy button in the Package and
Deployment Wizard, the following error message appears:
  Unexpected error number 429 has occurred: ActiveX component can't
create
object.
CAUSE
A file needed by the Package and Deployment Wizard does not exist or has
not
been properly registered on the development computer.
RESOLUTION
To resolve the problem, use these steps:
  a.. If the error occurs when you try to open the Package and
Deployment
Wizard, you need to unload the Package and Deployment Wizard, manually
register the file named Pdwizard.ocx, and then reload the wizard.
    1.. From the Add-Ins menu, choose Add-In Manager.
    2.. Select Package and Deployment Wizard from the list of available
add-ins.
    3.. Clear the Loaded/Unload check box in the Load Behavior section
of
the Add-In Manager dialog box and then close the dialog box.
    4.. Register the Pdwizard.ocx file by using the RegSvr32 utility. On
the
Windows Start menu, select Run and execute the following command:
    Regsvr32 "C:\Program Files\Microsoft Visual
Studio\VB98\WIZARDS\PDWIZARD\pdwizard.ocx"
    5.. From the Add-Ins menu, choose Add-In Manager.
    6.. Select Package and Deployment Wizard from the list of available
add-ins.
    7.. Check the Loaded/Unload check box in the Load Behavior section
of
the Add-In Manager dialog box and then close the dialog box.
  a.. If the error occurs just after you choose the Package or Deploy
button, the file named Hostwiz.dll needs to be manually registered.
    1.. Register the Hostwiz.dll file by using the RegSvr32 utility. On
the
Windows Start menu, select Run, and then execute the following command:
Regsvr32 "C:\Program Files\Microsoft Visual
Studio\COMMON\Wizards98\hostwiz.dll"
MORE INFORMATION
After the error occurs, the Package and Deployment Wizard menu item may
appear more than once in the Add-Ins menu. The additional menu item
exists
because the Package and Deployment Wizard Add-In terminated prematurely
and
was unable to remove the menu item. You can remove the extra menu item
by
using the Customize feature.

Ad hoc queries

 select max(cast(convert(varchar, convert(datetime, [CR_DATE], 103), 101) as date))  from OPENDATASOURCE (        'SQLNCLI'         ...