473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Unspecified Error in ASP.NET code

Hi,

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 1123

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

Similar topics

5
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) {...
4
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. ...
2
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...
1
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...
1
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.