Skip to main content
B
BMoeen
Participant
May 22, 2007
Question

Problem with DB Connection

  • May 22, 2007
  • 2 replies
  • 304 views
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???
This topic has been closed for replies.

2 replies

I
imnojudas
Participant
May 31, 2007
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.
D
delaneypub
Participating Frequently
May 29, 2007
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.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices