Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

No tables in database

Status
Not open for further replies.

Friskje

Technical User
Joined
Jan 20, 2005
Messages
2
Location
BE
I was working on a website in Dreamweaver MX 2004 under the operating system Windows 2000. I'm using 3 different databases and everything worked fine.
Then I had some trouble with my operating system so I installed Windows XP (Dutch). I wanted to continue working on my website so I re-installed dreamweaver and IIS.
Now every time I want to do run a wizard dreamweaver tells me that there are no tables in my database. My connection string still works, (Connetion was succesfully made), but I can't find my tables anymore!
I am using ASP vbscript with 3 access databases. I checked my databases they still contain all the data.
The website still works so I think it's a dreamweaver problem.
Does anybody have any ideas cause I don't have a clue anymore.

 
From the Macromedia TechNotes
Database connectivity fails with local ASP.NET and ASP servers

ASP: When using a local ASP test server running on XP SP2 with Dreamweaver (i.e. the Testing Server URL prefix is set to "localhost"), and you specify "Using driver on testing server" or "Using DSN on testing server," database connectivity 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."

Workaround: Download and install the Dreamweaver extension fix by Macromedia that resolves this issue (Ref. 179021). To use this extension, follow the steps below:

In Dreamweaver, select Site > Advanced > Remove Connection Scripts.
Quit Dreamweaver.
Install the extension.
Restart Dreamweaver and create a new database connection.
Note: This extension is compatible with Dreamweaver MX 2004 and Dreamweaver MX. The current version of the extension is 1.0.2. Version 1.0.1 resolved a database connectivity problem with the ASP VBScript server model. Version 1.0.2 includes the fixes in version 1.0.1 and also resolves compatibilty issues with Dreamweaver MX (version 6). You can see which version you have by opening the Extension Manager.

Cheech

[Peace][Pipe]
 
thank you very much for your reply, it works fine now!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top