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).
back to the top
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