![]() I always create my databases with a password. On the next screen, make sure the Data source is set to the “Microsoft SQL Server 2005 Compact Edition (.NET Framework Data Provider for SQL Server CE)”, if not click the Change button to launch a dialog where you can select it.įor Data Source make sure My Computer is picked, then enter the directory and path where you want your database stored. Note do NOT pick the Create New SQL Server Database… option, this works with full blown SQL Server such as SQL Server Express, not SSCE. Now right Click on Data Connections, and pick “Add Connection…”. First, if Server Explorer is not visible select View, Server Explorer from the menu. Instead, you can create the SSCE database right from within Visual Studio 2005. ![]() For example, if you will be deploying the database with your app, it’s not really necessary to write the code to create it. While it’s great for your app to be able to be able to create its own database(s), it’s not always necessary. In the past I showed how to create a new SQL Server Compact Edition (SSCE) database using code.
0 Comments
Leave a Reply. |