TechNote (Archived)

405 Method Not Allowed error when testing OLE DB and ODBC Connections

Issue

---

After applying the Dreamweaver MX 6.1 Updater, some Windows developers are reporting the following error when attempting to test OLE DB or ODBC database connections from the connections dialog box. The error occurs when a connection is defined as Remote, or Using Driver (or DSN) on Testing Server.

405 Method Not Allowed

Note: All ASP.NET connections are considered remote, so there is no option to select Local or Remote connectivity within that server model.

Another symptom of the problem occurs when attempting to use connections defined prior to applying the 6.1 Updater. In this case, while the connection is displayed in the Databases panel, no database information is available when the plus button is clicked to open the connection. Opening the connections dialog box and testing these connections also results in the 405 error.

Reason

---

The cause of this issue has yet to be determined, however, Macromedia engineers continue to investigate the source of the error.

There may be other reasons for the 405 error related to site structure and permissions, but that are unrelated to Dreamweaver. If connectivity worked correctly with Dreamweaver MX version 6.0, and the 405 error occurred after applying the 6.1 Updater, then you are experiencing this specific problem.

Solution

---

While the specific cause of the error is unknown, a work-around is available. Replacing the Scripts folder within the Dreamweaver program files has resolved the issue for most users. If this solution does not resolve the problem, please contact Dreamweaver Technical Support.

Complete the following steps to implement the work-around:

1. Download the scripts.zip file, which contains a replacement Scripts folder.
2. Close Dreamweaver MX.
3. Rename the Scripts folder, located in the following directory, to Scripts_bak.
   (Install location)\Dreamweaver MX\Configuration\Connections\
   
   Note: The default install location is C:\Program Files\Macromedia\.
4. Extract the contents of the downloaded Scripts zip file to the same directory.
   (Install location)\Dreamweaver MX\Configuration\Connections\
   
   Note: The ZIP file contains a new Scripts directory and its contents.
5. Delete the _mmServerScripts folder from the site root on the testing server. This must be done for each site experiencing the problem.
   • If you connect to the testing server via FTP, use a different FTP client to delete the folder. The _mmServerScripts folder is hidden in Dreamweaver's Site panel.
   • If you connect to the testing server over the network, use Windows Explorer to delete the _mmServerScripts folder.
6. Restart Dreamweaver MX.

Search Support

---