hello there, I came across this over the weekend with a fellow developer over the weekend...
Have any of you experienced any issues simliar to this with the JDBC driver with SQL 2000 server? 1. Two weeks ago, they switched over to MX and it bombed under load - it was producing constant sql deadlocks. They believe they were able to track down the problem with some stored procedures - why would this issue cropped up in MX and not in CF5. Is it because MX is not as forgiving as CF5? 2. Then another major error occurred: Operation failed on the data source named "whatever5sql". Reason of failure "[Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared." This has happened twice and it required the services to be restarted. It has been frustrating for the developer and the users. Management that MX was faster and more stable to justify buying it. They had to rollback to CF5 once and the developer doesn't want switch back at this time, otherwise the company just wasted $1500 (CDN). thoughts? thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184306 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

