|
 |
asp_databases thread: DSN vs Non-DSN connection
Message #1 by "Durwood Edwards" <durwoode@m...> on Thu, 9 Jan 2003 14:20:11
|
|
We have several ASP pages that display database information. We get the:
Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
Error about every 10-12 days. I have looked over the code many times and
think I have eliminated any errors there (HAHA). But in reviewing the time
frame in which this error started appearing, I think it began just after I
had converted all our connections to DSN (for future maintenance ease). Is
there any reason to think that DSN connections like this could produce
such a failure? Or do I need to look more closely at the ASP code itself?
There are several (5-6) pages and I can post code, but I don't want to
overwhelm the forum members.
Thanks
Durwood Edwards
Message #2 by "Ron Williams" <ronwilliams32@c...> on Thu, 9 Jan 2003 21:15:46
|
|
I have not seen that error, but if you send the code, ill reporduce it.
DSN will not be supported in the future, but it shouldnt cause any
problems now.
In my experience, when Access says something about the system, it is
talking about the Host computer or server, and not the database. too much
memory, too much disk space, i am not sure. running Access over a network
never helps either. if you send code, please send version of Access you
are using, how many concurrent users you normally have.
sorry i couldnt tell you more at this point.
ron
> We have several ASP pages that display database information. We get the:
> Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
[> Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
> Error about every 10-12 days. I have looked over the code many times and
t> hink I have eliminated any errors there (HAHA). But in reviewing the
time
f> rame in which this error started appearing, I think it began just after
I
h> ad converted all our connections to DSN (for future maintenance ease).
Is
t> here any reason to think that DSN connections like this could produce
s> uch a failure? Or do I need to look more closely at the ASP code itself?
T> here are several (5-6) pages and I can post code, but I don't want to
o> verwhelm the forum members.
> Thanks
> Durwood Edwards
Message #3 by "Carl E. Olsen" <carl-olsen@m...> on Fri, 10 Jan 2003 06:35:53 -0600
|
|
I have experienced unexplainable intermittent problems using DSNs. I
try to use a connection string (DSN-less) whenever possible.
> -----Original Message-----
> From: Durwood Edwards [mailto:durwoode@m...]
> Sent: Thursday, January 09, 2003 2:20 PM
> To: ASP Databases
> Subject: [asp_databases] DSN vs Non-DSN connection
>
> We have several ASP pages that display database information. We get
the:
>
> Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
> [Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
>
> Error about every 10-12 days. I have looked over the code many times
and
> think I have eliminated any errors there (HAHA). But in reviewing the
time
> frame in which this error started appearing, I think it began just
after I
> had converted all our connections to DSN (for future maintenance
ease). Is
> there any reason to think that DSN connections like this could produce
> such a failure? Or do I need to look more closely at the ASP code
itself?
> There are several (5-6) pages and I can post code, but I don't want to
> overwhelm the forum members.
>
> Thanks
>
> Durwood Edwards
> to unsubscribe send a blank email to leave-asp_databases-
> 1112136X@p...
Message #4 by "Durwood Edwards" <durwoode@m...> on Thu, 23 Jan 2003 20:19:24
|
|
Ron Thanks for your comments.
I doubt that we have more than 4-5 concurrent users accessing the database
at any one time. We normally have 75-100 concurrent users on our site
however.
I am afraid that we are stuck using Access for the forseable future for
these relatively small databases.
Once this error appears we have to reboot the server to clear it. I am
aware that improperly closed databases and failure to set recordsets to
Nothing can leak memory over time, but I do really believe I have covered
all those bases.
Below is the code for one of the pages:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../../Connections/connDSNmediators.asp" -->
<%
Dim familyMediators__MMColParam
familyMediators__MMColParam = "1"
if (Request.QueryString("chooseType") <> "") then
familyMediators__MMColParam = Request.QueryString("chooseType")
%>
<%
Dim familyMediators__MMColParam2
familyMediators__MMColParam2 = "1"
if (Request.QueryString("mnuCounty") <> "") then
familyMediators__MMColParam2 = Request.QueryString("mnuCounty")
%>
<%
set familyMediators = Server.CreateObject("ADODB.Recordset")
familyMediators.ActiveConnection = MM_connDSNmediators_STRING
familyMediators.Source = "SELECT * FROM mediators WHERE CGory LIKE '%" +
Replace(familyMediators__MMColParam, "'", "''") + "%' AND (COUNTY
LIKE '%" + Replace(familyMediators__MMColParam2, "'", "''") + "%') AND LTR
LIKE '%A%' ORDER BY COUNTY, [LAST NAME]"
familyMediators.CursorType = 0
familyMediators.CursorLocation = 2
familyMediators.LockType = 1
familyMediators.Open()
familyMediators_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
familyMediators_numRows = familyMediators_numRows + Repeat1__numRows
%>
<%
' *** Recordset Stats, Move To Record, and Go To Record: declare stats
variables
' set the record count
familyMediators_total = familyMediators.RecordCount
' set the number of rows displayed on this page
If (familyMediators_numRows < 0) Then
familyMediators_numRows = familyMediators_total
Elseif (familyMediators_numRows = 0) Then
familyMediators_numRows = 1
End If
' set the first and last displayed record
familyMediators_first = 1
familyMediators_last = familyMediators_first + familyMediators_numRows - 1
' if we have the correct record count, check the other stats
If (familyMediators_total <> -1) Then
If (familyMediators_first > familyMediators_total) Then
familyMediators_first = familyMediators_total
If (familyMediators_last > familyMediators_total) Then
familyMediators_last = familyMediators_total
If (familyMediators_numRows > familyMediators_total) Then
familyMediators_numRows = familyMediators_total
End If
%>
<%
' *** Recordset Stats: if we don't know the record count, manually count
them
If (familyMediators_total = -1) Then
' count the total records by iterating through the recordset
familyMediators_total=0
While (Not familyMediators.EOF)
familyMediators_total = familyMediators_total + 1
familyMediators.MoveNext
Wend
' reset the cursor to the beginning
If (familyMediators.CursorType > 0) Then
familyMediators.MoveFirst
Else
familyMediators.Requery
End If
' set the number of rows displayed on this page
If (familyMediators_numRows < 0 Or familyMediators_numRows >
familyMediators_total) Then
familyMediators_numRows = familyMediators_total
End If
' set the first and last displayed record
familyMediators_first = 1
familyMediators_last = familyMediators_first + familyMediators_numRows -
1
If (familyMediators_first > familyMediators_total) Then
familyMediators_first = familyMediators_total
If (familyMediators_last > familyMediators_total) Then
familyMediators_last = familyMediators_total
End If
%>
<html lang = "eng">
<head>
<title>Mediator List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="../../../CSS/general.css" type="text/css">
</head>
<body>
<h1><%= (Request.QueryString("chooseType")) %> Mediators for <%=
(Request.QueryString("mnuCounty")) %> County</h1>
<div align="center"><%=(familyMediators_total)%> Record(s) found</div>
<table width="90%" border="0" align = "center" cellpadding="6">
<tr valign = "top" style="font-weight:bold;">
<td valign="top" height="31" colspan="2">Contact</td>
</tr>
<%
While ((Repeat1__numRows <> 0) AND (NOT familyMediators.EOF))
%>
<tr valign = "top" >
<td NOWRAP height="160" style = "font-size:smaller;"
width="45%"><strong>Name:</strong>
<%=" "&(familyMediators.Fields.Item("FIRST
NAME").Value)%> <%=(familyMediators.Fields.Item("LAST NAME").Value)%
><br>
<strong>Address:</strong> <%=(familyMediators.Fields.Item
("ADDRESS1").Value)%><br>
<% IF(familyMediators.Fields.Item("ADDRESS2").Value)<>" " then
Response.Write
(" &
nbsp; ")
Response.write(familyMediators.Fields.Item("ADDRESS2").Value)
& "<br>"
end if %>
&nb
sp; <%=(familyMediators.Fields.Item("CITY").Value)%>, <%
(familyMediators.Fields.Item("STATE").Value)%> <%
(familyMediators.Fields.Item("ZIP").Value)%><br>
<br>
<strong>Phone:</strong> <%=(familyMediators.Fields.Item
("PHONE").Value)%><br>
<strong>Occupation:</strong> <%=(familyMediators.Fields.Item
("OCCUPATION").Value)%> <br>
<strong>Date Listed:</strong> <%=(familyMediators.Fields.Item
("LISTED/DENIED").Value)%><br>
</td>
<td align = "left" valign="top"style = "font-size:smaller;"
width="55%">
<% IF (familyMediators.Fields.Item("SERVING1").Value)="Statewide"
then
Response.Write ("also serving statewide")
end if %>
</td>
<tr>
<td colspan="2" valign="top" height="33">
<hr>
</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
familyMediators.MoveNext()
Wend
%>
</table>
<% If familyMediators.EOF And familyMediators.BOF Then %>
<p align = "center" style="font-size:larger;">Your search has returned
<em>no</em>
records for <%= (Request.QueryString("mnuCounty")) %> county. <br>
Be sure that you have selected both a type of mediator and a county.</p>
<% End If ' end familyMediators.EOF And familyMediators.BOF %>
<%
familyMediators.Close()
SET familyMediators = Nothing
%></body>
</html>
> I have not seen that error, but if you send the code, ill reporduce it.
> DSN will not be supported in the future, but it shouldnt cause any
p> roblems now.
> In my experience, when Access says something about the system, it is
t> alking about the Host computer or server, and not the database. too
much
m> emory, too much disk space, i am not sure. running Access over a
network
n> ever helps either. if you send code, please send version of Access you
a> re using, how many concurrent users you normally have.
> sorry i couldnt tell you more at this point.
> ron
> > We have several ASP pages that display database information. We get
the:
> > Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
[> > Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
> > Error about every 10-12 days. I have looked over the code many times
and
t> > hink I have eliminated any errors there (HAHA). But in reviewing the
t> ime
f> > rame in which this error started appearing, I think it began just
after
I>
h> > ad converted all our connections to DSN (for future maintenance
ease).
I> s
t> > here any reason to think that DSN connections like this could produce
s> > uch a failure? Or do I need to look more closely at the ASP code
itself?
T> > here are several (5-6) pages and I can post code, but I don't want to
o> > verwhelm the forum members.
> > Thanks
> > Durwood Edwards
Message #5 by "Charles M. Carroll" <darthcarroll@l...> on Thu, 23 Jan 2003 22:49:22 -0500
|
|
DSNs are very unreliable see:
DSNs by the way always use ODBC under the covers instead of OLEDB.
http://www.learnasp.com/learn/dbopen.asp
shows how to make a connection string that is much more reliable.
Based on the code you sent you are not using GetRows which will really
reduce the chance that will ever happen, see:
http://www.learnasp.com/advice/whygetrows.asp
WARNING: It is really hard to guarantee connections are closed within your
code despite your rs and conn close at end of script.
If any script reading a database hangs up IIS may terminate the script
PERIOD i.e.
open
DO UNTIL rstemp.eof
.....
rstemp.movenext
LOOP
Close
IF IIS kills script in middle of LOOP it kills it. The close code or the
rest of the code never runs.
http://www.learnasp.com/learn/isclientconnected.asp
Also if the user hits stop button scripts that are stuck still consume
resources unluss isclientconnected is used to drop out of the loop.
At 08:19 PM 1/23/2003 +0000, you wrote:
>Ron Thanks for your comments.
>
>I doubt that we have more than 4-5 concurrent users accessing the database
>at any one time. We normally have 75-100 concurrent users on our site
>however.
>
>I am afraid that we are stuck using Access for the forseable future for
>these relatively small databases.
>
>Once this error appears we have to reboot the server to clear it. I am
>aware that improperly closed databases and failure to set recordsets to
>Nothing can leak memory over time, but I do really believe I have covered
>all those bases.
>
>Below is the code for one of the pages:
>
><%@LANGUAGE="VBSCRIPT"%>
><!--#include file="../../../Connections/connDSNmediators.asp" -->
><%
>Dim familyMediators__MMColParam
>familyMediators__MMColParam = "1"
>if (Request.QueryString("chooseType") <> "") then
>familyMediators__MMColParam = Request.QueryString("chooseType")
>%>
><%
>Dim familyMediators__MMColParam2
>familyMediators__MMColParam2 = "1"
>if (Request.QueryString("mnuCounty") <> "") then
>familyMediators__MMColParam2 = Request.QueryString("mnuCounty")
>%>
><%
>set familyMediators = Server.CreateObject("ADODB.Recordset")
>familyMediators.ActiveConnection = MM_connDSNmediators_STRING
>familyMediators.Source = "SELECT * FROM mediators WHERE CGory LIKE '%" +
>Replace(familyMediators__MMColParam, "'", "''") + "%' AND (COUNTY
>LIKE '%" + Replace(familyMediators__MMColParam2, "'", "''") + "%') AND LTR
>LIKE '%A%' ORDER BY COUNTY, [LAST NAME]"
>familyMediators.CursorType = 0
>familyMediators.CursorLocation = 2
>familyMediators.LockType = 1
>familyMediators.Open()
>familyMediators_numRows = 0
>%>
><%
>Dim Repeat1__numRows
>Repeat1__numRows = -1
>Dim Repeat1__index
>Repeat1__index = 0
>familyMediators_numRows = familyMediators_numRows + Repeat1__numRows
>%>
><%
>' *** Recordset Stats, Move To Record, and Go To Record: declare stats
>variables
>
>' set the record count
>familyMediators_total = familyMediators.RecordCount
>
>' set the number of rows displayed on this page
>
>If (familyMediators_numRows < 0) Then
> familyMediators_numRows = familyMediators_total
>Elseif (familyMediators_numRows = 0) Then
> familyMediators_numRows = 1
>End If
>
>' set the first and last displayed record
>familyMediators_first = 1
>familyMediators_last = familyMediators_first + familyMediators_numRows - 1
>
>' if we have the correct record count, check the other stats
>If (familyMediators_total <> -1) Then
> If (familyMediators_first > familyMediators_total) Then
>familyMediators_first = familyMediators_total
> If (familyMediators_last > familyMediators_total) Then
>familyMediators_last = familyMediators_total
> If (familyMediators_numRows > familyMediators_total) Then
>familyMediators_numRows = familyMediators_total
>End If
>%>
><%
>' *** Recordset Stats: if we don't know the record count, manually count
>them
>
>If (familyMediators_total = -1) Then
>
> ' count the total records by iterating through the recordset
> familyMediators_total=0
> While (Not familyMediators.EOF)
> familyMediators_total = familyMediators_total + 1
> familyMediators.MoveNext
> Wend
>
> ' reset the cursor to the beginning
> If (familyMediators.CursorType > 0) Then
> familyMediators.MoveFirst
> Else
> familyMediators.Requery
> End If
>
> ' set the number of rows displayed on this page
> If (familyMediators_numRows < 0 Or familyMediators_numRows >
>familyMediators_total) Then
> familyMediators_numRows = familyMediators_total
> End If
>
> ' set the first and last displayed record
> familyMediators_first = 1
> familyMediators_last = familyMediators_first + familyMediators_numRows -
>1
> If (familyMediators_first > familyMediators_total) Then
>familyMediators_first = familyMediators_total
> If (familyMediators_last > familyMediators_total) Then
>familyMediators_last = familyMediators_total
>
>End If
>%>
>
>
><%= (Request.QueryString("chooseType")) %> Mediators for <%=
>(Request.QueryString("mnuCounty")) %> County
>
>
>
><%=(familyMediators_total)%> Record(s) found
>Contact
><% While ((Repeat1__numRows <> 0) AND (NOT familyMediators.EOF)) %>
>Name: <%=" "&(familyMediators.Fields.Item("FIRST
>NAME").Value)%> <%=(familyMediators.Fields.Item("LAST NAME").Value)% >
>Address: <%=(familyMediators.Fields.Item ("ADDRESS1").Value)%>
><% IF(familyMediators.Fields.Item("ADDRESS2").Value)<>" " then
>Response.Write (" &
>
>nbsp; ") Response.write(familyMediators.Fields.Item("ADDRESS2").Value) & "
>" end if %> &nb
>sp; <%=(familyMediators.Fields.Item("CITY").Value)%>, <%=
>(familyMediators.Fields.Item("STATE").Value)%> <%=
>(familyMediators.Fields.Item("ZIP").Value)%>
>
>Phone: <%=(familyMediators.Fields.Item ("PHONE").Value)%>
>Occupation: <%=(familyMediators.Fields.Item ("OCCUPATION").Value)%>
>Date Listed: <%=(familyMediators.Fields.Item ("LISTED/DENIED").Value)%>
><% IF (familyMediators.Fields.Item("SERVING1").Value)="Statewide" then
>Response.Write ("also serving statewide") end if %>
>
>----------
><% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1
>familyMediators.MoveNext() Wend %> <% If familyMediators.EOF And
>familyMediators.BOF Then %>
>
>Your search has returned no records for <%=
>(Request.QueryString("mnuCounty")) %> county.
>Be sure that you have selected both a type of mediator and a county.
><% End If ' end familyMediators.EOF And familyMediators.BOF %> <%
>familyMediators.Close() SET familyMediators = Nothing %>
>
>
> > I have not seen that error, but if you send the code, ill reporduce it.
>
> > DSN will not be supported in the future, but it shouldnt cause any
>p> roblems now.
>
> > In my experience, when Access says something about the system, it is
>t> alking about the Host computer or server, and not the database. too
>much
>m> emory, too much disk space, i am not sure. running Access over a
>network
>n> ever helps either. if you send code, please send version of Access you
>a> re using, how many concurrent users you normally have.
>
> > sorry i couldnt tell you more at this point.
>
> > ron
>
> > > We have several ASP pages that display database information. We get
>the:
>
> > > Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
>[> > Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
>
> > > Error about every 10-12 days. I have looked over the code many times
>and
>t> > hink I have eliminated any errors there (HAHA). But in reviewing the
>t> ime
>f> > rame in which this error started appearing, I think it began just
>after
>I>
>h> > ad converted all our connections to DSN (for future maintenance
>ease).
>I> s
>t> > here any reason to think that DSN connections like this could produce
>s> > uch a failure? Or do I need to look more closely at the ASP code
>itself?
>T> > here are several (5-6) pages and I can post code, but I don't want to
>o> > verwhelm the forum members.
>
> > > Thanks
>
> > > Durwood Edwards
>---
>[This E-mail scanned for viruses by Declude Virus]
Message #6 by "Charles M. Carroll" <darthcarroll@l...> on Fri, 24 Jan 2003 11:08:44 -0500
|
|
DSNs are very unreliable see:
http://www.learnasp.com/learn/dbopen.asp
shows how to make a connection string that is much more reliable.
DSNs by the way always use ODBC under the covers instead of OLEDB.
Based on the code you sent you are not using GetRows which will really
reduce the chance that will ever happen, see:
http://www.learnasp.com/advice/whygetrows.asp
WARNING: It is really hard to guarantee connections are closed within your
code despite your rs and conn close at end of script.
If any script reading a database hangs up IIS may terminate the script
PERIOD i.e.
open
DO UNTIL rstemp.eof
.....
rstemp.movenext
LOOP
Close
IF IIS kills script in middle of LOOP it kills it. The close code or the
rest of the code never runs.
http://www.learnasp.com/learn/isclientconnected.asp
Also if the user hits stop button scripts that are stuck still consume
resources unluss isclientconnected is used to drop out of the loop.
At 08:19 PM 1/23/2003 +0000, you wrote:
>Ron Thanks for your comments.
>
>I doubt that we have more than 4-5 concurrent users accessing the database
>at any one time. We normally have 75-100 concurrent users on our site
>however.
>
>I am afraid that we are stuck using Access for the forseable future for
>these relatively small databases.
>
>Once this error appears we have to reboot the server to clear it. I am
>aware that improperly closed databases and failure to set recordsets to
>Nothing can leak memory over time, but I do really believe I have covered
>all those bases.
>
>Below is the code for one of the pages:
>
><%@LANGUAGE="VBSCRIPT"%>
><!--#include file="../../../Connections/connDSNmediators.asp" -->
><%
>Dim familyMediators__MMColParam
>familyMediators__MMColParam = "1"
>if (Request.QueryString("chooseType") <> "") then
>familyMediators__MMColParam = Request.QueryString("chooseType")
>%>
><%
>Dim familyMediators__MMColParam2
>familyMediators__MMColParam2 = "1"
>if (Request.QueryString("mnuCounty") <> "") then
>familyMediators__MMColParam2 = Request.QueryString("mnuCounty")
>%>
><%
>set familyMediators = Server.CreateObject("ADODB.Recordset")
>familyMediators.ActiveConnection = MM_connDSNmediators_STRING
>familyMediators.Source = "SELECT * FROM mediators WHERE CGory LIKE '%" +
>Replace(familyMediators__MMColParam, "'", "''") + "%' AND (COUNTY
>LIKE '%" + Replace(familyMediators__MMColParam2, "'", "''") + "%') AND LTR
>LIKE '%A%' ORDER BY COUNTY, [LAST NAME]"
>familyMediators.CursorType = 0
>familyMediators.CursorLocation = 2
>familyMediators.LockType = 1
>familyMediators.Open()
>familyMediators_numRows = 0
>%>
><%
>Dim Repeat1__numRows
>Repeat1__numRows = -1
>Dim Repeat1__index
>Repeat1__index = 0
>familyMediators_numRows = familyMediators_numRows + Repeat1__numRows
>%>
><%
>' *** Recordset Stats, Move To Record, and Go To Record: declare stats
>variables
>
>' set the record count
>familyMediators_total = familyMediators.RecordCount
>
>' set the number of rows displayed on this page
>
>If (familyMediators_numRows < 0) Then
> familyMediators_numRows = familyMediators_total
>Elseif (familyMediators_numRows = 0) Then
> familyMediators_numRows = 1
>End If
>
>' set the first and last displayed record
>familyMediators_first = 1
>familyMediators_last = familyMediators_first + familyMediators_numRows - 1
>
>' if we have the correct record count, check the other stats
>If (familyMediators_total <> -1) Then
> If (familyMediators_first > familyMediators_total) Then
>familyMediators_first = familyMediators_total
> If (familyMediators_last > familyMediators_total) Then
>familyMediators_last = familyMediators_total
> If (familyMediators_numRows > familyMediators_total) Then
>familyMediators_numRows = familyMediators_total
>End If
>%>
><%
>' *** Recordset Stats: if we don't know the record count, manually count
>them
>
>If (familyMediators_total = -1) Then
>
> ' count the total records by iterating through the recordset
> familyMediators_total=0
> While (Not familyMediators.EOF)
> familyMediators_total = familyMediators_total + 1
> familyMediators.MoveNext
> Wend
>
> ' reset the cursor to the beginning
> If (familyMediators.CursorType > 0) Then
> familyMediators.MoveFirst
> Else
> familyMediators.Requery
> End If
>
> ' set the number of rows displayed on this page
> If (familyMediators_numRows < 0 Or familyMediators_numRows >
>familyMediators_total) Then
> familyMediators_numRows = familyMediators_total
> End If
>
> ' set the first and last displayed record
> familyMediators_first = 1
> familyMediators_last = familyMediators_first + familyMediators_numRows -
>1
> If (familyMediators_first > familyMediators_total) Then
>familyMediators_first = familyMediators_total
> If (familyMediators_last > familyMediators_total) Then
>familyMediators_last = familyMediators_total
>
>End If
>%>
>
>
>
>
><%= (Request.QueryString("chooseType")) %> Mediators for <%=
>(Request.QueryString("mnuCounty")) %> County
>
>
>
>
>
>
>
><%=(familyMediators_total)%> Record(s) found
>Contact
><% While ((Repeat1__numRows <> 0) AND (NOT familyMediators.EOF)) %>
>Name: <%=" "&(familyMediators.Fields.Item("FIRST
>NAME").Value)%> <%=(familyMediators.Fields.Item("LAST NAME").Value)% >
>Address: <%=(familyMediators.Fields.Item ("ADDRESS1").Value)%>
><% IF(familyMediators.Fields.Item("ADDRESS2").Value)<>" " then
>Response.Write (" &
>
>nbsp; ") Response.write(familyMediators.Fields.Item("ADDRESS2").Value) & "
>" end if %> &nb
>sp; <%=(familyMediators.Fields.Item("CITY").Value)%>, <%=
>(familyMediators.Fields.Item("STATE").Value)%> <%=
>(familyMediators.Fields.Item("ZIP").Value)%>
>
>Phone: <%=(familyMediators.Fields.Item ("PHONE").Value)%>
>Occupation: <%=(familyMediators.Fields.Item ("OCCUPATION").Value)%>
>Date Listed: <%=(familyMediators.Fields.Item ("LISTED/DENIED").Value)%>
><% IF (familyMediators.Fields.Item("SERVING1").Value)="Statewide" then
>Response.Write ("also serving statewide") end if %>
>
>----------
><% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1
>familyMediators.MoveNext() Wend %> <% If familyMediators.EOF And
>familyMediators.BOF Then %>
>
>Your search has returned no records for <%=
>(Request.QueryString("mnuCounty")) %> county.
>Be sure that you have selected both a type of mediator and a county.
><% End If ' end familyMediators.EOF And familyMediators.BOF %> <%
>familyMediators.Close() SET familyMediators = Nothing %>
>
>
> > I have not seen that error, but if you send the code, ill reporduce it.
>
> > DSN will not be supported in the future, but it shouldnt cause any
>p> roblems now.
>
> > In my experience, when Access says something about the system, it is
>t> alking about the Host computer or server, and not the database. too
>much
>m> emory, too much disk space, i am not sure. running Access over a
>network
>n> ever helps either. if you send code, please send version of Access you
>a> re using, how many concurrent users you normally have.
>
> > sorry i couldnt tell you more at this point.
>
> > ron
>
> > > We have several ASP pages that display database information. We get
>the:
>
> > > Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
>[> > Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
>
> > > Error about every 10-12 days. I have looked over the code many times
>and
>t> > hink I have eliminated any errors there (HAHA). But in reviewing the
>t> ime
>f> > rame in which this error started appearing, I think it began just
>after
>I>
>h> > ad converted all our connections to DSN (for future maintenance
>ease).
>I> s
>t> > here any reason to think that DSN connections like this could produce
>s> > uch a failure? Or do I need to look more closely at the ASP code
>itself?
>T> > here are several (5-6) pages and I can post code, but I don't want to
>o> > verwhelm the forum members.
>
> > > Thanks
>
> > > Durwood Edwards
>---
>[This E-mail scanned for viruses by Declude Virus]
|
|
|
View Cart
