Dear group, I'm getting a strange problem in ASP/IIS/Jet (not exactly sure which of these is responsible)
We have a customer inquiry tracking system (pretty much the typical one), and we are making a web interface for the customers to be able to see their inquiries. The system has its database in Access, and uses DAO for accessing it (i know, i know, but we are not planning to rewrite the code yet). The ASP pages don't access the database directly. They call methods in classes in an ActiveX DLL, which return the corresponding data. The DLL opens the database connection the first time one of its methods is called, and the connection stays open from then on. This all works perfectly. However, we have a very strange problem. Every once in a while, when someone tries to log on to the system (it's usually the first one in that day, or when i try to log on during the weekend), the first call to a method in the DLL that tries to access the database gives the following error: --------------------------------------------------------- DAO.Database (0x800A0C06) The Microsoft Jet database engine cannot find the input table or query 'Contactos'. Make sure it exists and that its name is spelled correctly. --------------------------------------------------------- This gets fixed as soon as we restart IIS. I assume this has to do with the fact that the system (or the DB connection) is not being used for a long time, and something breaks down. But the strange thing is that this doesn't happen Always, it's only every once in a while... Has anyone experienced this kind of problems before? Any ideas on what could be happening? Thanks in advance Daniel Magliola Cimatic SRL +5411 4787 5311 ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
