Solved

Unable to view SQL database tables in Dreamweaver MX

Posted on 2004-09-17
5
511 Views
Last Modified: 2010-05-18
(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
0
Comment
Question by:brayshaw_uk
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 12082671
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 12086264
check defult database for sql login that you use..
0
 
LVL 1

Author Comment

by:brayshaw_uk
ID: 12105529
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
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12327425
PAQed, with points refunded (150)

Computer101
E-E Admin
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now