Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use remote DSN to create a database connection, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

You can create a database connection in Dreamweaver using the DSN defined on the remote computer. If you want to use a remote DSN, you must define the DSN on the Windows computer running the application server (possibly IIS).

To create a database connection using a remotely defined DSN:

1. Define a DSN on the remote system running the application server.

two。 Open an ASP page in Dreamweaver, and then open the Database panel (window > Database).

Dreamweaver displays all connections defined for the site. Note: schemas or directories cannot be created in Microsoft Access.

3. Click the plus (+) button on the panel and select data Source name (DSN) from the pop-up menu. The data Source name (DSN) dialog box appears.

4. Enter a name for the new connection.

5. Select the use DSN on test server option at the bottom of the dialog box.

Macintosh users can ignore this step because all database connections use DSN on the application server.

6. Enter DSN.

You can click the "DSN" button to connect to the server and select from the DSN defined on it.

7. If necessary, fill in the username and password text boxes.

8. If necessary, click Advanced and enter a schema or directory name to limit the number of database items that Dreamweaver retrieves at design time.

9. Click Test.

Dreamweaver attempted to connect to the database. If the connection fails, review the DSN. If the connection still fails, check the settings of the folder that Dreamweaver uses to process dynamic pages.

10. Click OK.

The new connection appears on the Database panel.

Thank you for reading this article carefully. I hope the article "how to use remote DSN to create a database connection" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.