I have come across an interesting occurrence where CF mysteriously started to fail on a Stored procedure. The storedProc was working fine for a while and now it doesn't. The storedProc is executed in a cfquery (there seems to be an issue with the cfstoredproc tag and paraming timestamps), anyways it executes in SQL QUERY ANALYZER just fine. The SQL statement is good and generates no errors. Sometimes CF will leave an open pipe to the db server and lock up the database for 45 minutes. Anyone have any suggestions? Environment: NT 4.0 sp5 CF 4.5.2 MDAC 2.5.13 DataSource is setup as OLEDB NT4.0 sp5 SQL7.0 Located on same network. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
