Hi, I have a Win 2008 web server, 64 bit. On this system I have FB 2.1 64 bit installed and a couple of sites that connect to those databases over ODBC from old-style ASP (not ASP.Net) using ADO objects in VBscript.
I have configured system ODBC datasources for this purpose. It all usually works flawlessly, but on occasion, for no apparent reason, suddenly the db connections start failing. It seems to be related to the ODBC driver because in this "failing state": 1. I can still connect using FlameRobin and the databaes have no validation errors. 2. If I bring up the ODBC system datasource and hit "Test connection" it fails. Also the services that can be executed from the ODBC driver settings dialog (backup, restore, stats etc) also fail with connection error. The error I get when trying to connect from the ODBC driver services dialog is this: sqlcode -904, fbcode 335544792 - Cannot attach to services manager. And from "Test connection" in the data source: Open database 'C:\.....\...fdb' failed A system reboot always resolves the problem, but rebooting a web server is not very desirable. So: 1. Any ideas what might be causing this? 2. Any ideas how I can stop it from happening? 3. Anything I can do to get more info that might help locate the error in the driver, if there is such an error? E.g. trace/log mode, status reports from the driver, ...? 4. Is there any way I can reload just the driver without having to reboot the entire computer? Thanks, Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: kj...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
