[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Unable to view SQL database tables in Dreamweaver MX

Posted on 2004-09-17
5
Medium Priority
?
523 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
4 Comments
 
LVL 143

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 43

Expert Comment

by:Eugene Z
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

834 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