Setup for Oracle Providers for ASP.NET
2-8 Oracle Database 2 Day + .NET Developer's Guide
Where:
sid: Is the database service name
hostname: Is the database computer name
port: Is the port to use to communicate to the database
address name: Is a user-defined short name for the connect descriptor. This short
name will be used in the connection string of your .NET application.
Example 2–2 shows a sample tnsnames.ora file.
Example 2–2 Sample tnsnames.ora File
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
Setup for Oracle Providers for ASP.NET
Oracle Providers for ASP.NET store web application state inside the Oracle database,
under the context of a database user's schema. The administrator can create new
database users to store application state.
This database user does not map to a single physical user, but acts as a repository to
store ASP.NET information for all web site users. Thus, the application state of a single
web user or multiple web users may be stored inside this new database user's schema.
At runtime, the ASP.NET application connects to the database using the database
user's credentials, in the connection string.
To set up the Oracle database, database administrators must grant certain database
privileges to the Oracle Providers for ASP.NET database user schema. With these
privileges, the database user can create the tables, views, stored procedures, and other
database objects that Oracle Providers for ASP.NET require.
After the privileges have been granted, the database user then can run the Oracle
Provider for ASP.NET configuration scripts.
This section walks you step by step through the Oracle Providers for ASP.NET setup
for your database. You do not have to complete this section if you do not plan to
complete the ASP.NET provider portion of this tutorial (second half of Chapter 7). The
Oracle Providers for ASP.NET setup uses Oracle Developer Tools for Visual Studio,
which should be installed before beginning setup.
See Also: Oracle Net Services Administrator's Guide
Note: In this tutorial, the database user is called ASPNET_DB_USER,
to indicate that it is a Oracle Providers for ASP.NET database user.
See Also: Oracle Providers for ASP.NET Developer's Guide for a
complete reference
我的内容管理
展开
