Solved

Unable to view SQL database tables in Dreamweaver MX

Posted on 2004-09-17
5
515 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 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 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

860 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