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
LVL 1
brayshaw_ukAsked:
Who is Participating?
 
Computer101Connect With a Mentor Commented:
PAQed, with points refunded (150)

Computer101
E-E Admin
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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?
0
 
Eugene ZCommented:
check defult database for sql login that you use..
0
 
brayshaw_ukAuthor Commented:
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

0
All Courses

From novice to tech pro — start learning today.