ASP.NET & Dreamweaver users: Database Failure

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

jsabarese

Thread Starter
Guest
Joined
Jan 9, 2005
Messages
21
i didn't know whether to put this in the software or coding forum... i guess it's really a software question... i hope someone can use the info here.

According to several users who want to use ASP.NET as a server side scripting language for web applications seeking help in Dreamweaver support forums, a common problem occurs when a database connection is established using the "+" in the Database tab of Dreamweaver's Application window. These users experiencing the problem, myself included, meet a seemingly insurmountable obstacle of the Database tables NOT showing in the Database tab of the Application window after the connection has been made. In particular, this problem reportedly occurs only for Windows XP SP2 users.

i discovered this issue while working through the tutorial on pages 101 and subsequently pages 68-73 of the DW_Getting_Started.pdf, a tutorial which DW owners should find included in the Dreamweaver documentation.

There are several resources and suggested fixes available which offer possible workarounds to solve this disappearing database table problem-- one being to install a Dreamweaver Extension, the "SP2 DB Fix" available here http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19515

I've read some reports which suggest that this fix doesn't solve their problem, however it did work for me.

Now that i've been able to establish the database connection, and add the Recordset (or DataSet as it is named by ASP.NET), I've encountered another problem. Proceeding through the same tutorial, as instructed, I inserted items from the Recordset into the aspx page, and then applied repeat region in order display more than one record called from the recordset. This being the final procedure for this aspx page, to demonstrate that all of the steps have been followed correctly up to this point, and to display the dynamic data being pulled from the recordset created, the tutorial then instructed me to enable DW's "Live Data" view. When i select View > Live Data (or press the Live Data button near the Code/Split/ Design view buttons) the Recordset (DataSet) disappers from the Bindings tab in the Application window! If i deselect Live Data, the Recordset returns.

I tried previewing in the Browser, but instead of a preview as with a static html page, IE prompts me to open or save the file. If i select "open", the file is then opened in Dreamweaver, and all of the images are missing due to broken links-- as if the folder structure / relative paths are not correct. however, if i select the same file from Remote View in the DW Files window, all of the images are shown.

Does anyone know if my problem is yet another DW / SP2 / ASP.NET glitch, as was the case w/ the invisible db tables, or could this possibly be a result of an error in my DW Local/Remote Site setup?

I suppose this is the point where i should bag Dreamweaver and try hand-coding some ASP.NET. if i were to go that route, do you have any suggestions for a "beginner's" editor?

I have had much more success w/ ColdFusion and Dreamweaver, that's for certain! I'm not giving up on ASP.NET and Dreamweaver yet, although i probably should. I'm confident that someone has the answer to solve this problem DW. suggestions? i'd guess that most people working in ASP.NET do NOT use Dreamweaver, so i'm curious what you have to say. DW users, i'm hoping for your input as well.

THanks!
 

eddie5659

Moderator
Malware Specialist
Joined
Mar 19, 2001
Messages
37,286
Hiya

As you haven't had much response in Software, I've moved you to Web Development for a better response :)

eddie
 

jsabarese

Thread Starter
Guest
Joined
Jan 9, 2005
Messages
21
Thanks! I have since switched over to trying MS Visual Web Developer Express Beta 2, which i recommend investigating as it is incredibly easy to make web apps in no time!
But, i'd still like to hear about a solution to the DW problem, although i will likely continue to work more w/ MS VWD and leave Dreamweaver behind.

Believe me, i avoid using M$ products as much as the next guy, but this new app is unbelievable-- unless i'm missing something horribly wrong w/ it, i think it just might put the dynamic web app development world on it's ear once word gets around-- that is, for anyone going the ASP.NET 2.0 route.

if you don't believe me, go here http://lab.msdn.microsoft.com/express/vwd/videos/default.aspx
and finish the Lesson 02: Creating a Web Forms User Interface. i think you'll be amazed as well. (sorry for derailing the thread! i am curious to see what direction this thread goes after this)
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Top