• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Connecting to a Database

When you have a lot of data about your site visitors, you'll want to save that information so that you can use the content. You can save the information in a form to a database by creating a database connection. A database connection is a connection that specifies the name, location, and type of database you want to access. You can create a new database, connect to an existing one, or connect to the sample Northwind database to try out the process. FrontPage comes with a wizard that creates one form for the visitor to submit information and another form for you to track the results. The Web site enables you to view, update, delete, or add records. To view the data once you set up the connection, your Web site must be hosted or published on a Web server configured with Active Server Pages (ASP), Active Data Objects (ADO), FrontPage 2002 Server Extensions or later or SharePoint Team Services, and Internet Information Server (IIS) version 4.0 (or later).

Create a Database Connection

Click the New button list arrow on the Standard toolbar, and then click Web Site.

Click Database Interface Wizard icon.

Click OK.

Click the option to create an ASP or ASP.NET page, and then click Next.

Click the option to create a new base, connect to an existing one, or connect to the sample Northwind database, and then click Next.

For the purposes of this example, create a new database.

Type a name for your database connection, and then click Next.

Edit the list of columns and submission fields for the database using Add, Modify, Delete, Move Up or Move Down, and then click Next.

Click Next to continue.

Select the table or view you want to use.

Specify a location for the database files (use the default location provided or click Browse to select a location), and then click Next.

Click Next to continue.

Select the check boxes for the database interface pages you want to use, and then click Next.

Type a user name, password, and password confirmation.

Click Finish.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint