Create a connection using a remote dsn – Adobe Dreamweaver CC 2015 User Manual
Page 555
548
Dynamic sites, pages and web forms
Last updated 6/3/2015
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.
You can use a locally defined DSN to create a database connection in Dreamweaver.
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, and then open the Databases panel (Window > Databases).
3
Click the Plus (+) button on the panel and select Data Source Name (DSN) from the menu.
4
Enter a name for the new connection, without spaces or special characters.
5
Select the Using Local DSN option and choose the DSN you want to use from the Data Source Name (DSN) menu.
If you want to use a local DSN but haven’t defined one yet, click Define to open the Windows ODBC Data Source
Administrator.
6
Complete the User Name and Password boxes.
7
You can restrict the number of database items Dreamweaver retrieves at design time by clicking Advanced, and
entering a schema or catalog name.
Note: You cannot create a schema or catalog in Microsoft Access.
8
Click Test to connect to the database, and then click OK. If the connection fails, double-check the connection string
or check the settings for the test folder Dreamweaver uses to process dynamic pages.
Create a connection using a remote DSN
Note: This section assumes you have set up an ASP application. It also assumes a database is set up on your local computer
or on a system to which you have network or FTP access.
Note: Dreamweaver can retrieve only server DSNs created with the Windows ODBC Data Source Administrator.
You can use a DSN defined on a remote computer to create a database connection in Dreamweaver. If you want to use
a remote DSN, the DSN must be defined on the Windows computer running your application server (probably IIS).
Note: 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.
1
Define a DSN on the remote system running your application server.
For instructions, see the following articles on the Microsoft website:
• If the remote computer runs Windows 2000, see Microsoft Knowledge Base Article 300596 at
• If the remote 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).
3
Click the Plus (+) button on the panel and select Data Source Name (DSN) from the menu.
4
Enter a name for the new connection, without spaces or special characters.