| Forzato 2005-04-26, 12:26 am |
| 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)"
|