Macromedia dreamweaver 8-using dreamweaver User Manual

624

Chapter 26:  Database Connections for ASP Developers

Creating a DSN connection 

You can use a DSN to create an ODBC connection between your web application and your 
database. A DSN is a name containing all the parameters needed to connect to a specific 
database using an ODBC driver. For more information, see 

You can define the DSN on a local or remote Windows computer. 

Related topics

■

Creating a connection using a local DSN

You can use a locally defined DSN to create a database connection in Dreamweaver. If you 
want to use a local DSN, the DSN must be defined on the Windows computer running 
Dreamweaver.

To create a database connection with a locally defined DSN:

1.

Define a DSN on the Windows computer running Dreamweaver.

For instructions, see the following articles on the Microsoft website:

■

If the computer runs Windows 2000, see Microsoft Knowledge Base Article 300596 at 

 

■

If the computer runs Windows XP, see Microsoft Knowledge Base Article 305599 at 

 

2.

Open an ASP page in Dreamweaver, then open the Databases panel (Window > 
Databases).

Dreamweaver displays all the connections defined for the site.

NO

TE

Because you can only specify an ODBC driver in a DSN, you must use a connection 
string if you want to use an OLE DB provider. For more information, see