Link to home
Start Free TrialLog in
Avatar of brayshaw_uk
brayshaw_ukFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Unable to view SQL database tables in Dreamweaver MX

(sry if this is wrong section)

Im trying to use dreamweaver mx to create a asp .net website connecting to an sql database. i can create the connection in dmx and it tests successfully, but i cannot view any tables that have been created. (nb. these do work, i have written some pages myself with no problems - dont have time to do it all).

any one please can help much appreciated. (ask if u need more info)

thankyou
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Are you connecting to the correct database, maybe to the master db instead of your db, or tables have been created in master db instead of your db?
check defult database for sql login that you use..
Avatar of brayshaw_uk

ASKER

well, unfortunately these are things that i have already tried, thx anyhow.

i seem to have located the problem, and it's all down to winxp.sp2 and/or win2003server.sp1(beta), or so it says on macromedia website

Database connectivity fails with local ASP.NET and ASP servers
http://www.macromedia.com/support/dreamweaver/ts/documents/dw_xp_sp2.htm

so, ive had to uninstall service packs on both machine, and now it works =/

so, if any anyone knows how to get around this problem, please let me know

thanx

ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial