Microsoft SQL Server CE Connection

About Microsoft SQL Server CE

SQL Server Compact Edition contains the run-time bits that can be used to develop applications and to deploy applications on desktop computers and on Tablet PCs. SQL Server Compact Edition is a powerful yet lightweight relational database engine. SQL Server Compact Edition supports familiar SQL syntax. Additionally, SQL Server Compact Edition provides a development model and an API that are consistent with SQL Server. Therefore, you can more easily develop desktop applications by using the RTW version of SQL Server Compact Edition than by using SQL Server Mobile. SQL Server Compact Edition includes new features such as |DataDirectory| substitution string support and ClickOnce support so that deployment is easy.

Connection

Comments

User fields

Creating New Connection

• In the Name Text Box type in a new name for the SQL Server Compact Edition connection you are about to create
• Select Database name
• Click OK to close the connection properties window

Video Tutorial

Used by

1. BDE Reader
2. BDE Writer
3. Database Loop Action
4. Sql Script Action
5. Sql Data Check Action
6. Check Connection Action
7. SQL To Text Dynamic Action
8. SQL To XML Dynamic Action
9. SQL To Insert Dynamic Action
10. SQL To Excel Dynamic Action
11. SQL To QVD Dynamic Action
12. SQL To QVX Dynamic Action
13. Select Value Action
14. SQL Record to Variables Action
15. SQL to Variables Action