| Author |
 Topic  |
|
AnonJr
Moderator
United States
5768 Posts |
 Posted - 25 August 2005 : 09:51:10
|
Bear with me as I give you the background. It will help understand the problem....
The IS department, in its infinite wisdom, will not let me use any databases other than Access - because I am a programmer in a department other than IS. 
Back in Nov. 2004 I moved the old, Perl-based Training and Development site from the NT4 server they had me on, to the new Win2K server (there is a story here too, but I digress).
Instead of moving everything over to the new server, I upgraded and created new versions of all the custom Perl programs - in ASP since I was told that I had to change servers and 'oh, by the way, Perl will not be installed on the new server.' 
Back to Nov. 2004 - the new site goes up, and there aren't any problems - just complaints from people who don't like change. I haven't made any significant changes to the code since. I've added a bug fix here, and a new feature there, but the core programs are intact.
This brings me to the problem at hand. In the past 3 months the Jet engine has just quit. Everything is running fine, and then all of a sudden, any attempt to start a connection is met with :
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/departments/education/sb2/inc_header.asp, line 106
I figured I would use the forum so you guys could see just what line of code is causing the problem.
Its not just the forum software though, any page that has any type of connection to any of the access databases gets the same error.
Searches on the MSDN haven't turned up anything, and every time its happened before, my buddy in IS just re-boots the server and all is good. He says that there isn't anything in the logs, and I have no way to check - I'm not allowed access .
Any thoughts? I don't want to just have to re-boot and pray every month or so. I want to say it has to do with the site exceeding the capabilities of the Jet engine... but how do I prove that to convince them to let me upgrade?
---------
As a side note, as I was typing this up the IS guy called and let me know that he re-booted the server... and all is working for now. According to him we are using the latest version of MDAC with all the patches... however I was told that we were using the latest version of VBScript, and later found out we weren't....
---------
Thoughts? |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 25 August 2005 : 10:00:22
|
Those unspecified errors are difficult to fix. Using a Jet OLEDB driver, the latest Jet service pack can perhaps diminish the times this occurs, but not even that is assured. I remember last month there was a similar error being caused by disk quotas being reached for the user in question: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=59001
If you're using a JetOLEDB connection maybe try changing it to an ODBC one. It may, as in the previous linked post, show a different error message that will get you in the right path to fix the error. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 25 August 2005 10:02:18 |
 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 August 2005 : 10:21:18
|
quote:
Using a Jet OLEDB driver, the latest Jet service pack can perhaps diminish the times this occurs
Whatever version we are using, I've been assured that we have the latest patches... unfortunatly, I've found that what I'm told and what is there are different things some times...
quote:
I remember last month there was a similar error being caused by disk quotas being reached for the user in question: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=59001
I've got a meeting next week with the Server Admin. to see if I can at least move up to the MSDE... I'll ask about the disk quotas then.
quote:
If you're using a JetOLEDB connection maybe try changing it to an ODBC one. It may, as in the previous linked post, show a different error message that will get you in the right path to fix the error.
I am using the OLEDB drivers. Since the problem went away with the last re-boot I'll have to wait until the problem comes back to try a different connection type... a step I hope I won't be able to try  .
Thanks for the help... If I had hair I would have been pulling it out every time this problem comes up (today marks incident #5 in the last 4 months). I hate just re-booting and praying it doesn't come back.
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 25 August 2005 : 10:23:07
|
| What makes this so frustrating is that all the online tests, flyers for classroom-based classes, and other training materials are all run from a database. When data access is unavailable, the site is essentially useless. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 September 2005 : 08:01:21
|
[sigh] I came in to work this morning to find that it had happened again.... they are stonewalling me on the MSDE at the moment.... and per ruirib's suggestion I tried switching the drivers. I now get this error:Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x8007000E)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x888 Thread
0x930 DBC 0xeb851bc Jet'.
/departments/education/sb2/inc_header.asp, line 106
Time to do a search for registry key issuses ....
Some days. |
Edited by - AnonJr on 07 September 2005 08:01:49 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 September 2005 : 09:07:38
|
Done my search, and most of them were "Switch to the OLEDB connection ... ok that worked" or uppon switching to the OLEDB connection string the error became fairly evident. (permissions et al)
None of that applies... and I can't seem to find out from the server admin if disk quotas are in place. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 September 2005 : 09:33:07
|
If IT are being uncooperative to the point that it's affecting your ability to do your job properly, maybe you should go over their heads and get someone to give them a kick in the arse.
|
 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 - 07 September 2005 : 09:52:48
|
quote:
Originally posted by ruirib
Did you see this one: http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295297 ?
Try the fix. It may shed additional light on the cause for the error.
Checked that the first time. Permissions are all good as far as I can tell..
quote:
Originally posted by ruirib
If IT are being uncooperative to the point that it's affecting your ability to do your job properly, maybe you should go over their heads and get someone to give them a kick in the arse.
Been down that road too. Part of the problem is that because I am in 'Training and Development' and not 'IS' I am considered a 'Security Risk' 
It doesn't matter that I was hired as a programmer, or that I have a degree in Computer Programming, or that I was two semesters away from finishing a second degree in Network Admin. My boss and I went up to the head of IS and they will not budge.  I can't get access to any database other than access, I can't get access to any programming software outside of Flash and Dreamweaver (and that took a 6 mo. fight).
I'd rant more, but that would be counter-productive. |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 07 September 2005 : 10:12:20
|
Surely there's someone over IS who you can go to? You've been hired to do a specific job but you're not being allowed proper access to the tools required to perform those duties properly so how can they expect you to do that job?
|
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 - 07 September 2005 : 10:22:00
|
I think the next step up would be one of the VPs, but my boss is unwilling to go the next step up at this point.
On a different note, I've started going back through recent events to see if there was anything that might coincide with whats been going on... the only thing I can think of is that a few months ago (I don't know the exact date) a new Perl script was put on the server (yeah, the same Perl that they said wouldn't be on the new server). Its suposed to manage the online library of Nursing/Personnel policies for the hospital. All the policies are in Word format. I think that each open policy is chewing up a connection to the server - and possibly causing the problem when too many people have policies open at one time.
I'm not too certain of this, but I'm about to go through the Perl code (if I have access) and see what I can figure out.
Scratch that - I don't have access. I can't get in touch with the Server Admin. Isn't this grand.
Much fun. |
Edited by - AnonJr on 07 September 2005 10:43:34 |
|
|
|
Nertz
Junior Member
Canada
341 Posts |
Posted - 07 September 2005 : 11:12:20
|
Sounds to me like IS is the 'Unspecified error' and they need the reboot. |
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.
www.fathers-4-justice-canada.ca |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 September 2005 : 11:16:07
|
Some days, I can get my work done, and all is good.
Some days, I'd like to do just that and give the people in IS a good "re-boot"
But that is another topic for another time... |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 07 September 2005 : 11:47:46
|
Don't know if this will help but I recently had a problem caused by too many open share sessions but it was on W 2003. I think it also may apply to W 2000. I cannot find the article on MSDN at the moment but I will post it when I do.
All the fix required was two registry changes to increase the no. of available work items. It would also make sense to convert those Word Documents to html pages and have IIS serve them.
Can you set up performance monitor to log the amount of open sessions or work items? Is there anything in the event log? Is the website or any website on the server serving pages from a unc share? |
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:01:45 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 07 September 2005 : 12:01:54
|
I don't have access to the server or its logs.... I have a drive mapping to a folder and aside from managing permissions on my folder, that is it.
I have a Upload class (I'm not allowed to install components) I use for stuffing files into a BLOB/OLE Object field in SQL Server/Access that serves the files without using share sessions or open connections etc. Its worked wonderfully so far (with access the file sizes have to be kept down though), but the server admin doesn't seem interested in it. I've mentioned it the last three times this problem has happened.
If you find the article pleas let me know. I have a funny feeling that the Word Docs are in this problem somehow.
While it would make sense to convert the docs to HTML or even PDFs, the IS guy doesn't want to have to keep making the change himself, and they don't want to buy the software (we have an actual policy against free software - don't even get me started). And I know that Word has a "Save to HTML" feature, but they seem unwilling to use it.
I've been using a free program that I've installed that I just haven't mentioned yet... and I convert the Word Docs that get sent to me for the online presentations to PDFs and stuff them into the database. It takes all of 2 min to get updates up with the program and the DB setup that I put together... but the server admin's not interested. [sigh] |
|
|
|
Topic |
|
Topic Locked
