thank you. I will have a look at it.
>>> [EMAIL PROTECTED] 11/15/2004 11:44:27 AM >>> apart from reviewing the cf code you may want to look into the jTDS drivers available from http://jtds.sourceforge.net/ they are regarded as considerably more stable and also more performant than microsoft's own offering ----- Original Message ----- From: "Lawrence Ng" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 15, 2004 8:37 PM Subject: MX sql driver issues > 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:184311 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
