| Author |
 Topic  |
|
Podge
Support Moderator
Ireland
3776 Posts |
 Posted - 07 September 2005 : 12:57:45
|
This isn't the article I was referring to but the fix looks the same - http://support.microsoft.com/default.aspx?scid=kb;en-us;221790&sd=tech
It refers to IIS not being able to connect to a unc share because the OS is running out of work items (which is not the case with IIS here) but if there are a lot of shares on the server and people using them then making more work items available should not have any adverse affects.
I don't envy your situation. The IS Dept. has no interest in helping you as their responsibility is security. Your interest is in getting your application to work 100% of the time. From experience I can guarantee you that you won't get anywhere unless you find a sympathetic ear in IS division or go to someone who can overule them. If there is such a person I think you should clearly outline how their policies are adversely affecting your area of work or division as a whole and present it to him/her. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
Edited by - Podge on 07 September 2005 12:58:22 |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 September 2005 : 13:14:01
|
Thanks for the link. Fortunatly, I've found a Dr. here who has been a sympathetic ear. He's the IS liason for the drs, and he has just recently started helping with this.... though, progress has been excruciatingly slow.
I'm sure that eventually this will get worked out. In the meantime, its frustrating as all heck.
Thanks again for the help guys, I'll let you know if I find the ultimate cause of this. |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 09 September 2005 : 18:06:52
|
Update on the situation:
- I was told that the MSDE was installed on the server and that I will be able to migrate my apps over to it.... after the class I have to teach on Monday I hope to find out
- I was also told that the problem had to do with "NT Licencing issues"
- I was informed that the number of connections allowed has been bumped up to 2000
... we'll see how all of this plays out ... |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 12 September 2005 : 07:26:43
|
quote:
Originally posted by AnonJr
- I was also told that the problem had to do with "NT Licencing issues"
Or so IS's excuse of the day calendar told them! 
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 12 September 2005 : 14:59:41
|
quote:
Originally posted by Shaggy
black]Or so IS's excuse of the day calendar told them!
[/black]
I had seen where someone put something like that together, but I can't seem to find it any more.... |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 13 September 2005 : 05:35:12
|
[Link] (first link on the page)
Probably not what you're thinking of but good for a giggle anyway 
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 October 2005 : 17:13:49
|
I hate dreging up an old topic like this but the problem hasn't stopped.
MSDE is installed on the web server, but I don't have access to it.  No one is returning my calls about it.
And since this was last replied to, its happened twice. I get error #-2147467259 (Unspecified error). I've added the "On error resume next" to config.asp and in inc_header.asp, right after the first DB connection I have it checking for this error. If it finds it, it re-directs to tempdown.asp.
All IS is doing is re-starting the server, and everythings fine again. Max connections have been increased. My morale has been decreased. I am completely frustrated with this. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 October 2005 : 23:10:56
|
Have you downloaded the mdb and run a compact & repair on it? Maybe you have a corrupted memo field that is causing an error only when it's accessed.
Unspecified Error means that Jet generated the error and ASP doesn't know what it is.
I imagine other posts above have mentioned that misconfigured or underpowered servers can cause this error sporadically.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 October 2005 : 07:01:08
|
I have indeed run compact and repair on all the databases. So far, all the data seems intact. After a server re-start, everything runs fine.
I truely believe I've tapped out what Access can do for the system I've built. But, since I don't seem to be getting access to anything else any time soon, I'm looking at trying to find another way to squeeze a little more life out of this.
As mentioned above, this system has been running fine for almost a year. It was only recently that this problem has started. However, the amount of information that has accumulated is impressive.
I'll post back any further results that I find. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 October 2005 : 09:11:44
|
| Probably there is some resource being exhausted in the system, which would explain why a server reset fixes the issue. May be something else, but it is very annoying that such an expressive error message was chosen to describe this. Other than reseting the server, it doesn't look like you can do much more, except upgrading to MSDE or even something else. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 October 2005 : 14:43:54
|
Yeah, "Unspecified Error" does me about as much good as "If you don't know why I'm mad at you, I'm definately not going to tell you" 
I still think it has a lot to do with all the Word docs. and the way they are served to the client. I've been trying like all heck to get at least MSDE ... and you can see up above when I was last promised that would happen.
For now I've got it checking for that error on the first DB connection of the main pages, and if it finds it, it re-directs to a more "eye friendly" error page. I've been out of the office all day, and I'll be teaching the better part of next week. Maybe I'll write a little program to send them an e-mail every morning until I get access to a DB server Then again, if I do that I may end up seeing if anybody here is looking to hire a programmer.
"Have laptop. Will travel." |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 October 2005 : 14:46:57
|
If you want to get fancy you can write some debugging code that inspects the connection object error collection and see what the "real" error message that's returned to asp actually is. I've done it in the past but I don't have any sample code handy.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 October 2005 : 19:36:55
|
The error collection returns error# -2147467259 (Unspecified error). I got that by doing Response.Write(Err.Number)
If there is something I'm missing please let me know as I'd really like to figure out what is going on. This is frustrating me to no end. |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 08 October 2005 : 08:37:52
|
hmmm. Next time this happens I'll have to try that. Learn something new every day. 
Forgive me though if I do hope I don't get a chance to try this due to not seeing this error again. |
|
|
|
Topic |
|
Topic Locked
