Edit the connection properties as necessary 3 Click the Test button to confirm your settings in Java

Draw QR-Code in Java Edit the connection properties as necessary 3 Click the Test button to confirm your settings

connection dialog box Dreamweaver saves your changes to the database connection Configuring ASP Database Connections

To delete an ASP database connection in Dreamweaver, follow these steps:

(Mac) the database connection you want to delete and choose Delete Connection from the drop-down list that appears An alert box appears to confirm the deletion

Gathering database connection information Adding a database connection Editing or deleting a database connection

reamweaver supports several languages: PHP, ASP, ASPNET, JSP, and ColdFusion In this chapter, we show you how to set up a database connection in ASPNET using Dreamweaver You find out how to add, edit, and delete a database connection

The best way to simplify connecting to a database from ASPNET is by gathering the necessary information about your database To make a connection in ASPNET to a database, here s what you need to know: Type of database you are connecting to (for example, SQL Server, Access, Oracle) Host name of the database server, or the IP address if no host name is available Username and password to access your database Name of the database to which you are trying to connect; in the case of a file-based database such as Access, the location of the database file

Dreamweaver offers two ways to connect to a database in ASPNET: OLE DB connection: With this method, you enter the information about your database server, and ASPNET uses that information to connect directly to your database Connecting directly to a database requires

ASPNET to run a driver program to be able to speak directly with your specific type of database Because the OLE DB driver talks directly to the database, it s faster than other drivers but requires extra steps (such as downloading and installing the driver) OLE DB drivers are available for download from the provider of the database For example, Microsoft supplies Access and SQL Server OLE DB drivers as part of its MDAC download at http://msdnmicrosoft com/data/mdac/downloads/ To download OLE DB drivers for Oracle databases, visit http://wwworaclecom/technology/software/ tech/windows/ole_db/indexhtml These packages come with installers that guide you through the process of installing the OLE DB driver on your computer SQL Server connection: This setting is specific to connecting with MS SQL Server databases and won t work with any other type of database The SQL Server connection option is nearly identical to the OLE DB connection option for MS SQL Server, except that you don t have to give Dreamweaver a Provider value in the SQL Server connection option Go ahead and create a SQL Server connection if using SQL Server; otherwise create an OLE DB database connection Before you create an ASPNET database connection, you must first create a new dynamic ASPNET page Creating a new dynamic ASPNET page enables Dreamweaver to interact with the database using database connections through ASPNET

To create a new dynamic ASPNET page, follow these steps:

This setting makes your page XHTML-compliant Select the default option, which is XHTML 10 Transitional

After you create a new dynamic ASPNET page, you can establish the database connection You can create an OLE DB connection using either the templates or data link properties, which we cover in the next section An alternative to connect to a SQL Server database is through the method provided in the Microsoft NET Framework, which we discuss later in the chapter in the section titled, Building a SQL Server connection

Because it s a common choice, the SQL Server database connection has its own connection type You can create a SQL Server database connection by using OLE DB as well Which one you use makes no difference, but you need to use OLE DB if you re connecting to a database other than SQL Server