HOW TO: Deploy Your MSDE 2000 Solution with the Package and Deployment Wizard

Article translations Article translations
Article ID: 325016 - View products that this article applies to.
This article was previously published under Q325016
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SUMMARY

This article provides general guidelines about how to deploy the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) with a Microsoft Visual Basic solution by using the Package and Deployment Wizard (PDW).

MSDE 2000 Deployment with PDW

To successfully deploy your Visual Basic solution that uses MSDE 2000, you must make sure that you deploy all required MSDE 2000 components with your Visual Basic custom solutions. (This is similar to the process of deploying the Access run-time version.) You can complete the MSDE 2000 deployment (redistribution) process either manually or automatically as shown below:

Manual Redistribution of MSDE 2000

You can create a Standard Setup Package by using PDW to redistribute all required MSDE 2000 files to your target computers, together with your Visual Basic solution. Then, you can use these redistributed MSDE 2000 files to manually setup MSDE 2000 on your target computers.

For additional information about how to setup MSDE 2000, click the article number below to view the article in the Microsoft Knowledge Base:
231923 HOWTO: Distribute the Microsoft Data Engine (MSDE 2000) With the Package and Deployment Wizard (PDW)

Automatic Redistribution of MSDE 2000

You can automate your MSDE 2000 redistribution process by using a custom installation program that permits automatic deployment of MSDE 2000 solutions on your target computers.

For additional information about how you can automate your MSDE 2000 redistribution process, click the article number below to view the article in the Microsoft Knowledge Base:
234626 SAMPLE: Setup1.exe Fully Automating MSDE 2000 Setup with the Package and Deployment Wizard (PDW)

Important Considerations

When you deploy your Visual Basic MSDE 2000 solution with PDW, you must make sure that you attach your custom MSDE 2000 database when the deployment process is completed. This permits you to use your custom database with your application. If you fail to do this, you generate a connectivity error with your Visual Basic application.

For additional information about 'Using a Custom Database with MSDE 2000', click the article number below to view the article in the Microsoft Knowledge Base:
231923 HOWTO: Distribute the Microsoft Data Engine (MSDE 2000) With the Package and Deployment Wizard (PDW)
When you work with Unicode string constants in Microsoft SQL Server (and MSDE 2000), you must put a capital letter "N" before all Unicode strings.

For additional information about the capital letter 'N' before all Unicode strings, click the article number below to view the article in the Microsoft Knowledge Base:
239530 INF: Unicode String Constants in SQL Server Require N Prefix


REFERENCES

For additional information about the Setup Toolkit, click the article number below to view the article in the Microsoft Knowledge Base:
189738 HOWTO: Run Setup1.vbp in the Design Environment

Properties

Article ID: 325016 - Last Review: February 27, 2014 - Revision: 3.0
APPLIES TO
  • Microsoft Visual Studio 6.0 Enterprise Edition
Keywords: 
kbnosurvey kbarchive kbhowtomaster kbdatabase kbdeployment KB325016

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com