Problem with DB Connection

[BMoeen]

Hi
I am just learning DW MX 2004. I have created successfully a connection to an Access DB on remote server, using both Connection String and DSN. In either case the TEST runs perfect. Then when I click on the Connection and then Tables, it says "No Tables". I have tried it many times and each time the result is the same. Any ideas what I may be missiing???

[delaneypub]

I don't know for certain, but I've had similar results when the ID and password I used to create the ODBC DSN did not have the proper permissions for the tables. So, I was able to connect to the DB but not see any tables.

[imnojudas]

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19515
Read the section for 'Database connectivity fails with local ASP.NET and ASP servers' had the same problem, followed the directions exactly...the second time, and it cleared it up.