Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Programming » .NET application programming » SQL Anywhere ASP.NET Providers


Adding the SQL Anywhere ASP.NET provider schema to the database

To implement the SQL Anywhere ASP.NET providers you can create a new database, or add the schema to an existing database.

To add the schema to an existing SQL Anywhere database, run SASetupAspNet.exe. When executed, SASetupAspNet.exe connects to an existing SQL Anywhere database and creates tables and stored procedures required by the SQL Anywhere ASP.NET providers. All SQL Anywhere ASP.NET provider resources are prefixed with aspnet_. To minimize naming conflicts with existing database resources you can install provider database resources under any database user.

You can use a wizard or the command line to run SASetupAspNet.exe. To access the wizard, run the application, or execute a command line statement without arguments. When using the command line to access the SASetupAspNet.exe, use the question mark (-?) argument to display detailed help for configuring the database.

 Setting up the database connection
 Specifying a resource owner
 Selecting features and preserving data

A whitepaper called Tutorial: Creating an ASP.NET Web Page using SQL Anywhere is available to demonstrate how to use SQL Anywhere and Visual Studio 2010 to build a database-driven ASP.NET web site. See [external link]