Hi Guys

I have a problem with Dreamweaver MX. I have a database connection and the tables and fields are displaying in the datasets and the server behaviours but when I run the pages, it just throws up a page with the code's content? This of course disappears when I remove the dataset. I am a tad lost? Is the local host correct. I have set the folders up in www.root dir. Other files that I just hard coded work?

Did you install IIS and the .NET Framework on your server?

if so, in what order?

Cheers,

Imar

I am not sure about .NET Framework? Does this come bundled with Dreamweaver or ISS? I have had some experience using Dreamweaver MX before. IIS is installed as part of Windows XP Professional. I do know this is working because I have hard coded some scripts and they do display.

EDIT: I am using "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\Inetpub\wwwroot\18983022\Database\OpenDa y.mdb;
Persist Security Info=False"

The url test was successful. I am just dumbfounded?

The .NET Framework is a separate download and enables you to create ASP.NET applications.

The term "dataset" made me think you're creating ASP.NET pages, but maybe you're not. What kind of pages are you creating? That is, what server side technology are you using?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

You are right about the dataset. I am doing this on asp.net although originally I was hard coding recordsets in asp. However I no longer have any time to do this (there are millions of them),as I have to meet a deadline in three weeks. I am building an open day system for a University that requires about 5 people to build it, yet I am expected to do all the work. After getting no help from the technical staff on coding issues I decided to just go ahead and build the site in Dreamweaver MX. Its not the first time I have used Dreamweaver and have found it to be a great tool in the past. However my problems are not so much with coding but simply forgetting how I set the thing up before. All files have been deployed to the bin, I have set up my folders in the root dir. One thing though, should your local remote folder be a different address from your testing server? Strangely the information such as the tables is establishing a connection.


I think I have some idea where I am going wrong. I have been coded some working pages on asp, not asp.net. Obviously its not working because I am not using the .net framework. I remember using MX a few years ago on a separate machine and having the same problem. That time I built a web site for an estate agents. The problem was solved when I installed some file. It must have been the framework exe file. My searches on google are indicating this is the reason it ain't working.

The database is connection often looks at your local system. This depends on how you set up the connection though.
So, even if you can access the database from within Dreamweaver, there is no guarantee it works on your live server.

You can set the Testing and the Remote folder to be the same, although that's often not the case.

If you don't have the .NET framework, get it here: http://msdn.microsoft.com/netframework/ and install it on your local machine and on your remote server (if the two are not the same).

Are you mixing asp pages and aspx pages in the same site? This will work, but the production server needs to support both technologies.

If all this doesn't solve your problems, can you elaborate a bit about your setup and the problems you're experiencing?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar

I was going to mix them but won't now. I have got the .NET framework and will install it as soon as I can. Hopefully it'll work.

Thanks

Well now I am just lost. I have the .net framework extension in, IIS set up and still it would only display the code on the IE window

<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicK eyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="DataSet1"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Project\Database\OpenDay .mdb;Persist Security Info=False" %>'
DatabaseType='<%# "OleDb" %>'
CommandText='<%# "SELECT * FROM StudFeed" %>'
Debug="true"
> </MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<%# DataSet1.FieldValue("StudentID", Container) %>
<%# DataSet1.FieldValue("StudName", Container) %>
</body>
</html>



This was a test page. I set up the local, remote, testing servers as C:\Inetpub\wwwroot\project\

The http address is http://localhost/project/

Sounds like a configuration issue to me. Make sure you install ASP.NET *after* you installed IIS or otherwise IIS isn't aware of ASP.NET.

You can also run the tool aspnet_regiis. Search this forum for it and you'll find some useful pointers.

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

If you mean install the .net framework after IIS then I did that, however I installed MX before IIS.