Technote Details :: Unable to retrieve tables from this connection

Issue

When using a local ASP testing server running on Windows XP with Service Pack 2 installed, and you specify "Using DSN on testing server" when connecting to a database from Dreamweaver, the connection fails. If you click the Test button in the Custom Connection String or Data Source Name (DSN) dialog box, it says the connection was made successfully. However, if you then try to browse the tables in the Databases panel or create a recordset, the database tables do not display or you get the following error message: "Unable to retrieve tables from this connection, click on the 'Define...' button to test this connection."

Reason

This issue is caused by the installation of Service Pack 2 on machines running Windows XP. You can find more information about this issue and other problems caused by the installation of Windows XP Service Pack 2 in this Dreamweaver Technote:
Dreamweaver and Windows XP Service Pack 2

Solution

To solve this problem, download and install the Dreamweaver extension  that resolves this issue.

To use this extension, follow the steps below:

  1. In Dreamweaver, select Site > Advanced > Remove Connection Scripts.
  2. Quit Dreamweaver.
  3. Install the extension.
  4. Restart Dreamweaver and create a new database connection.

Donna Prouty - 02-23-2007 05:45:40 GMT +2

 When using a local ASP testing server running on Windows XP with Service Pack 2 installed, and you specify "Using DSN on testing server" when connecting to a database from Dreamweaver, the connection fails. If you click the Test button in the Custom Connection String or Data Source Name (DSN) dialog box, it says the connection was made successfully. However, if you then try to browse the tables in the Databases panel or create a recordset, the database tables do not display or you get the following error message: "Unable to retrieve tables from this connection, click on the 'Define...' button to test this connection."

I have downloaded the workaround extention for DW to address this XP service pack2 problem. I have followed the steps to the letter (several times) using a 3rd party FTP client to remove the serverscripts folder on the remote server and have had others check to make sure I did not miss anything and am still receiving the same error when I try to create a record set.  Help! does anyone have any ideas why the fix is not working?

Thanks, Donna
Home > Support > Knowledge Base > Technote Details
General Products
Search the Knowledge Base
Advanced Search
Most Popular Technotes
Latest Technotes
© Adobe Systems Romania. All rights reserved.