PDA

View Full Version : IIS and Dreamweaver site set ups



Kaizer
06-24-2005, 03:29 AM
Hi again. I have a new question. Here is the story:

1. I have created a small DBase in Access with one table = "Friends"
2. I have created a DSN = "FriendsDSN" in Data Sources (ODBS) indicating my DBase
3. I have created a Virtual Directory = "DB_Friends" in IIS indicating the folder where my DBase is located
4. I have created the site = "Friends" in Dreamweaver where
Local Root Folder = C:\Documents and Settings\Administrator\My Documents\Sites\
Server Model = ASP VBScript
Access = Local/Network
Testing Server Folder = Local Root Folder
URL Prefix = http://localhost/DB_Friends/
5. I have made a DSN Connection = "FriendsConn" with "Using DSN on Testing Server" option selected. Test was successful.
6. Now, when I am trying to make the Recordset in "Server Behaviors" choosing FriendsConn it gives me an error "Unable to retrieve tables from this connection. Click on the 'Define...' button to test this connection"
:banghead:
Have you had this problem? Do you know how to fix it?
PS What is wierd is that I have this problem on my home machine with XP on it. My office computer with Win2000 is not giving this error.