I thought that this was that rather well documented issue where SQL Server had actually maxed out its connections and was refusing to accept any more but the data direct drivers return the rather less helpful 'no more data' error...
If you can, increase your max permissable connections in SQL and decrease the connection timeout in CFMX so that the connections are maintained but for less time... This way, you are keeping the perf benefits of maintaining the connections whilst staving off the site hitting the maximum connections... If you get the right balance, you should never see the problem... Also make sure you have all the related patches for CFMX and the related SequeLink drivers installed from the MM site... Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201602 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
