472,964 Members | 2,403 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,964 software developers and data experts.

Unspecified Error in ASP.NET code


I'm running a Windows 2000 server with all the latest security patches and
stuff. I am using an ADODB.Recordset to perform all my requests for
information from a database. I noticed some newsgroups said to use the Jet
engine instead of ODBC, so I am now using the Jet engine. I use rs.open and
rs.close to open and close the databases.

Here's the problem: If I leave my server running for a while, accepting
requests and providing responses, I eventually get a crash on my "rs.open"
line. It says "Unspecified Error"... any ideas? I've checked to make sure
that each recordset is closed by the end of each page. I also checked the
permissions on the IWAM's temp directory (as per an MS KB article). I even
went to make sure that the ASPNET account has rights on its temp folder. I
did notice that the IWAM's temp folder contains a bunch of temp files, all
locked (as in, I can't delete them). The only way to fix this problem that I
have seen is to restart the IIS server every time it fails, but in a
production environment, that's not good.

I was also thinking about converting my code to ADO.NET, but I have no idea
where to begin. All my code is contained in the ASPX file, so there's no
"behind the scenes" coding, or runat="server" attributes. I would like to
keep it that way too, as the server is a rather old one (P2 467 MHz, 327 MB
of RAM...). I did do a Microsoft Certified Course (Intro to VB.NET), but I
can't remember how to use the connection. data adaptor, and data reader
objects. There was something about creating the XML schema too, but I can't
remember that either.

Can someone help me? Thanks.
Jul 24 '05 #1
0 1116

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Dave | last post by:
Hi All C# ADSI samples that I run cause unspecified errors. If I translate them into VB.NET they run fine. Here's an example: public string getEmail(string LDAPPath, string username) {...
by: RM | last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ...
by: Jim Lacenski | last post by:
I have a VB class that uses .NET and ADODB to write into an Excel spreadsheet (via Jet) on a server as part of a web application. ADODB is used instead of ADO.NET because it greatly simplifies the...
by: T8 | last post by:
I have a asp.net (framework 1.1) site interfacing against SQL 2000. It runs like a charm 99% of the time but once in a while I get the following "unspecified error". Sometimes it would resolve by...
by: Siegfried Heintze | last post by:
I'm using a third party hosting service. I presently have a Web Service on this hosting service's server that loads and executes a native mode DLL. This demonstrates that the hosting service has...
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.