Select the product you need help with

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

Article ID: 325016 - View products that this article applies to.

This article was previously published under Q325016

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

(http://support.microsoft.com/kb/231923/EN-US/ )

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

(http://support.microsoft.com/kb/234626/EN-US/ )

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

(http://support.microsoft.com/kb/231923/EN-US/ )

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

(http://support.microsoft.com/kb/239530/EN-US/ )

INF: Unicode String Constants in SQL Server Require N Prefix