ASP.NET Forum

**webgurl** · 01-08-2005, 09:39 PM

Yes this is me above, going around in circles!

My first posting .

I am using Dreamweaver MX and PWS.

I have searched the web high and low, read everything I possibly can, made postings on NGs all over the place without any help and I am getting desperate here! I have 2 weeks to get a database driven site working and already after one week, I still cannot do this!!! I have made a basic test site and an access data base. All my connections are working - I just cannot view the live data.

Here are my settings:

1. Create folder in C:\Inetpub\wwwroot and name it aaaaa
2. Make sure PWS is running. Access is set to read and scripts
3. IN DWMX setup -
- local root folder is D:\My Documents\aaaaa\
- remote folder is C:\Inetpub\wwwroot\aaaaa\
- testing server is C:\Inetpub\wwwroot\aaaaa\
- URL prefix is http://localhost/aaaaa/

Try to preview in browser - page not found
Try to view live data, get server application error window

Are my settings correct?

any advice will be appreciated as I am feeling pretty stupid right now

**ACJavascript** · 01-09-2005, 06:22 PM

Hey,

#1 - What server are you running?
#2 - Show us the code.

We will try our best to help you out!

**Republikin** · 01-09-2005, 06:27 PM

As well as what ACJavascript suggested are you programming in ASP or ASP.NET?

**webgurl** · 01-09-2005, 07:33 PM

Personal web server - PWS
asp with javascript

<%@LANGUAGE="JAVASCRIPT"%>

<%
var rsEmployees = Server.CreateObject("ADODB.Recordset");
rsEmployees.ActiveConnection = MM_conAAAAA_STRING;
rsEmployees.Source = "SELECT * FROM Table1";
rsEmployees.CursorType = 0;
rsEmployees.CursorLocation = 2;
rsEmployees.LockType = 3;
rsEmployees.Open();
var rsEmployees_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
rsEmployees_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>contact</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="13%"> </td>
<td width="57%">Company Name</td>
<td width="30%"> </td>
</tr>
<tr>
<td><a href="index.htm">Home</a><br>
<a href="about.htm">About</a><br>
<a href="contact.asp">Contact </a></td>
<td>
<table width="100%" border="1" cellspacing="0" cellpadding="5">
<tr>
<td>
<% while ((Repeat1__numRows-- != 0) && (!rsEmployees.EOF)) { %>
First Name
<%
Repeat1__index++;
rsEmployees.MoveNext();
}
%>
</td>
<td>Last Name</td>
<td>Position</td>
<td>Email</td>
</tr>
<tr>
<td><%=(rsEmployees.Fields.Item("FirstName").Value )%> </td>
<td><%=(rsEmployees.Fields.Item("LastName").Value) %> </td>
<td><%=(rsEmployees.Fields.Item("Position").Value) %> </td>
<td> <a href="mailto:"><%=(rsEmployees.Fields.Item("Email" ).Value)%></a> </td>
</tr>
</table>
</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</body>
</html>
<%
rsEmployees.Close();
%>

.................................................. .....

<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_conAAAAA_STRING = "dsn=AAAAA;"
%>

**webgurl** · 01-09-2005, 10:32 PM

FYI

after reading I think every tech note and not resolving my problem, I removed PWS and
reinstalled and it works!

**ACJavascript** · 01-09-2005, 10:51 PM

Glad you resolved it