A typical problem solving method of Dreamweaver connection database

dreamweaver| Solution | Connect to the database | The first question first, the error is as follows "HTTP Error 404 cannot find the file."

1 There is no test server running on the server machine.
2 The test server specified for this site is not mapped to Http://localhost/_mmserverscripts/MMHTTPDB.aspURL. Verify that the URL prefix is mapped to the root of your site. " However, the IIS server is functioning properly at this time. This problem occurs because the site's test root directory uses localhost, as long as it is changed anywhere else. Note, however, that using the same setting in Dreamweaver and IIS (assumed as Chinese here), the Dreamweaver test server URL prefix uses http://localhost/chinese/. When IIS is set up, use aliases with just the Chinese, and others follow normal settings. At this point, you will find that you can use the F12 preview page in Dreamweaver. The custom connection string is then used to succeed.

The second question, "Use the driver on test server" test to "successfully create the connection script", but cannot find the table in the database when binding. Tip "Cannot retrieve a table from this connection ..."

When using a driver on local server test, it is OK to specify that the initialization string does not conform to the OLE DB rule.

This problem is better solved because of the compatibility problem after using XP-SP2. 1. Download the plugin DOWNLOAD.MACROMEDIA.COM/PUB/DREAMWEAVER/EXTENSIONS/SP2DBFIX1.0.2.MXP and install the boot plugin.
2. In Dreamweaver, open the file before the connection, "site"→"advanced"→"Remove connection script."
3. Delete the folder connections and _mmserverscripts that were created before the connection.

It's okay to reconnect.

But here is a very strange problem, I installed the plugin on another machine and still not normal after the boot, prompted "HTTP Error 405 does not allow the use of this method" and "An error occurred, unable to upload mmhttpdb.asp." Another program is using this file, the process is inaccessible ", But it was closed to success. Do not know if the plugin is a bug.

　

You will be able to operate your database in Dreamweaver.

The first problem is the same in PHP and ASP.net, but I have no research on them, I don't know if it's the same reason.