"NO TABLES FOUND" error despite database connection

[Forzato]

Hello all,

I'm using XP sp2, updated Dreamweaver MX 2004, a simple MS Access database,
using a remote testing server via OLE DB connection script, DSN-less, ASP.NET
pages, ('Hostway' host server has support for all the above)...

When Dreamweaver connects to database all is well...( >Application >Database >
+ >Test) DMX 04 says... "Connection was made successfully"

However, when adding a Dataset ( >Application >Bindings >Dataset > + ) DMX 04
says... "NO TABLES FOUND"

NOTE: Table is uploaded to server and in database directory, DMX 04 has
uploaded the '/bin' folder and dll's, DMX 04 has also uploaded the 'MM
scripts', the 'remote' and 'testing' servers connect when tested in Site
Manager, passwords checked and confirmed, no DMX extensions installed...

Any ideas???

Thanks in advance!

PS: There are few posts on this symtom, but no solutions that I can find. 'D
B Cooper' left a post with similar syptoms and claimed a solution... I tried
and no change in the "No tables found". However the Cooper 'solution' * is
rather vague (so I'm not sure if more detail wouldn't promote a fix for this
issue)

* D B Cooper's proposed 'solution' :
"You have to create a ODBC DATA SOURCE and CREATE a SYSTEM DSN connection to
your server.
The Reason: I believe that .net can connectors are able to make this
connection with out this but Dreamweaver uses the older Pre .net connection to
get to the servers and they require a DSN Entry.
To Get to the DSN stuff : To open Data Sources (ODBC), click Start, and then
click Control Panel. Double-click Administrative Tools, and then double-click
Data Sources (ODBC)"

[Forzato]

OK,

D B Cooper was right! (even if he didn't survive the parachute escape!)

After further examination of the >Application >Data Sources (OBDC) Panel...
the problem is indeed solved! The key is clicking the 'Network' button in the
'System DSN' tab of the OBDC Data Source window... then creating a FTP
connection to the root of the site on the remote server... then a reboot of the
local PC and voila! Dreamweaver now shows the tables from the database!

[Forzato]

WTF! Same error as before!

ANY ideas?

[Forzato]

See this link for more on this thread...
[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=263&thre[/url]
adid=996081&CFID=3463774&CFTOKEN=4542b4c3f3ce902a-8E002F34-AA90-B2CC-092A45A70E8
5D667&jsessionid=483069963af21d7e2440

[sjb34]

peace, be calm. I have been going through the exact same problem. Why in this
day and age there is nothing that can spell this out clear and concise the
exact steps and how to do it, I have no idea. Yes I have found lots of bits of
info from replies to various forums but they are all so vague, and just seem to
miss the point. Yes, programmers may be total geniuses, genii? , but why oh why
cannot someone somewhere - and I don't mean on this forum btw - have devised a
written walkthrough of how to set up asp with IIS and SQL server to get them
all talking to each other. What I want to do is simple. As I am a student of
web technology I want to practice uploading to a 'remote' computer, albeit my
own desktop from my laptop. I found PHP and MySQL no problems to set up, but
this one is just a headache. You found any solutions yet? or at least where to
find some more info!!!????!!!!

[Eddy Miller]

Hi Forzato and sjb34

See my answer to your other thread and my own post. There is a TechNote in
Support called "Dreamweaver and Windows XP Service Pack 2" that explains a bug
that stops Dreamweaver from being able to retrieve tables even after it claims
to have made a database connection.

The solution is to delete the mmServerScripts, download and install an
Extension and then delete and recreate the DSN or DSN-less connection string.

After 13 very long consecutive days trawling Macromedia help, forums,
technotes and Microsoft support, and trying every configuration under the sun,
I couldn't agree more with sjb34 that a simple, clear, guide to all the
potential steps needed to set up a database connection would be most welcome.
Would that be so hard?