All, This morning my Cold Fusion server started acting very strange. I noticed that any page with a query that I pulled up was taking extremely long to load. most of the pages timed out or display a SQL Error. After some serious digging around it turned out that the problem was our Client Variables Datasource. Due to a server move the MS SQL7 server that stores the client variables became unavailable. This apparently caused the Cold Fusion templates to time out on database connects. The strange thing here is that our primary datasource is a Postgres Database on a Linux system. None of the Cold Fusion templates use client variables. The main concern for me was the lack of informative messages concerning the absence of the session database. Cold Fusion just gave SQL Query errors on my application database. not in the screen errors or in the log files was there any mention of the client variables datasource. Does anyone know if this is the desired behaviour of Cold Fusion? It seems that this might be an area for improvement. Specs: Linux Redhat Cold Fusion 4.5 Postgres DB (application) ODBC MS SQL 7 DB (Client Varsa) MERANT (different machine) Leon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
