Sporadic OLE DB errors; None of the historical fixes from this forum have resolved it.

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

I have inherited maintenance of an installation of the Liberum helpdesk.  It was happily working without error on a Windows 2000 server with IIS5.  I had to repurpose the server so I moved the site to an existing Windows Server 2003 box with IIS6.  After some trials and tribulations I have the helpdesk up and running.  Now problems is when the helpdesk person logs in early in the morning they receive the following error:

 

Application error
Number: -2147467259 (0x80004005)
Source: Microsoft OLE DB Provider for ODBC Driver
Description: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
No more information is available.

After an hour it goes away.  Sporadically, this issue returns when doing searches or when users click on helpdesk desk links from emails.

 

• I have enabled “Parent Paths”
• I have allowed active Server Pages and server side includes
• Modified default.asp pages in the rep and user folders as follows: (as per http://www.liberum.org/forums/t/43.aspx )

Added “Call SetAppVariables” above “Dim cnnDB, sid”
Added “<!-- #include file = "../settings.asp" -->” above ”<!-- #include file = "../public.asp" –“

• Relaxed NTFS permissions on the db and website folder.
• I have other websites working fine on this server.
• The db is on a the same local drive as the websites.
• Relaxed permissions on the ODBC registry keys as per: http://support.microsoft.com/kb/306345
• No backups or scheduled task are running during the time these issues are reported.

My Configuration:

Window Server 2003 R2 SP2 / IIS 6
Access file for data storage (DBType "3")
NT Authentication for users
The MDB file is in a folder that has read/write permissions for the IUSR and IWAM users.
Software version: Liberum Help Desk 0.97.3

I am at my wits end and I really appreciate any help you can give me.

Thanks,

-Paul