Any ideas, anyone?

Den 2012-01-20 08:57 skrev Kjell Rilbe såhär:
> 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
>
Any ideas, anyone?

Kjell

-- 
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kj...@datadia.se
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



------------------------------------------------------------------------------
Try before you buy = See our experts in action!
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-dev2
_______________________________________________
Firebird-odbc-devel mailing list
Firebird-odbc-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel

Reply via email to