Dreamweaver - ASP pages gone AWOL

Author

ASP pages gone AWOL

dukla

2005-05-27, 7:18 pm

Hi there,

I'm pretty far down the line developing my first database driven app, but
today its all gone a bit wrong, as all my .asp pages that were previously just
fine, are now only working sporadically - they sometimes load up just fine, but
hitting refresh loses them. Or maybe they won't load up, but a refresh will
bring them up. At the moment its fa rmore miss than hit, and a complete mystery.

I created a new basic page to try to figure out at what point any error was
kicking in - but its literally caused as soon as a recordset is created.

The code for his basic page is just :

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_connTemp_STRING
Recordset1.Source = "SELECT * FROM Amendments"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
temp asp
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>

The error message is unhelpful (to me at least) :

Error Type:
Provider (0x80004005)
Unspecified error
/library pages/temp.asp, line 8

where line 8 is :

Recordset1.ActiveConnection = MM_connTemp_STRING

any ideas what is happening here?

Its just an intranet site at my work so is sitting on the network - could it
be some sort of network glitch perhaps?

(As I haven't really changed anything)

It did seem to start going AWOL when I saved a copy of a page, and was
tinkering about adding some sort functionality to the results, but even if I
screwed up some code in that temp page, I don't see how it could have screwed
all my .asp pages.

Any ideas or pointers hugely appreciated.

Cheers,
Iain

Paul Whitham TMM

2005-05-31, 11:14 pm

That extremely helpfully error message usually has to do with the way that
you are connecting to the database rather than the pages themselves. If you
are using a DSN then try deleting it on the server and recreating it. This
sometimes helps, although I have found that DSN-Less connections are often
better for intranets.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
www.valleybiz.net

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
www.macromedia.com/support/forums/team_macromedia

"dukla" <webforumsuser@macromedia.com> wrote in message
news:d770r8$61t$1@forums.macromedia.com...
> Hi there,
>
> I'm pretty far down the line developing my first database driven app, but
> today its all gone a bit wrong, as all my .asp pages that were previously
just
> fine, are now only working sporadically - they sometimes load up just
fine, but
> hitting refresh loses them. Or maybe they won't load up, but a refresh
will
> bring them up. At the moment its fa rmore miss than hit, and a complete
mystery.
>
> I created a new basic page to try to figure out at what point any error
was
> kicking in - but its literally caused as soon as a recordset is created.
>
> The code for his basic page is just :
>
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> 
> <%
> Dim Recordset1
> Dim Recordset1_numRows
>
> Set Recordset1 = Server.CreateObject("ADODB.Recordset")
> Recordset1.ActiveConnection = MM_connTemp_STRING
> Recordset1.Source = "SELECT * FROM Amendments"
> Recordset1.CursorType = 0
> Recordset1.CursorLocation = 2
> Recordset1.LockType = 1
> Recordset1.Open()
>
> Recordset1_numRows = 0
> %>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd">
> <html>
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
> <title>Untitled Document</title>
> </head>
>
> <body>
> temp asp
> </body>
> </html>
> <%
> Recordset1.Close()
> Set Recordset1 = Nothing
> %>
>
> The error message is unhelpful (to me at least) :
>
> Error Type:
> Provider (0x80004005)
> Unspecified error
> /library pages/temp.asp, line 8
>
> where line 8 is :
>
> Recordset1.ActiveConnection = MM_connTemp_STRING
>
> any ideas what is happening here?
>
> Its just an intranet site at my work so is sitting on the network - could
it
> be some sort of network glitch perhaps?
>
> (As I haven't really changed anything)
>
> It did seem to start going AWOL when I saved a copy of a page, and was
> tinkering about adding some sort functionality to the results, but even if
I
> screwed up some code in that temp page, I don't see how it could have
screwed
> all my .asp pages.
>
> Any ideas or pointers hugely appreciated.
>
> Cheers,
> Iain
>