Well the problem I have been having during the week has now been solved, this was very confusing, and leads me to the conclusion that CFMX's migration of datasources is a bit pants.
I feel a bit of a twat not having checked the the JDBC documentation supplied with CFMX, but the problem lay with the drivers. All datasources registered bar one or two with CF.5 where registered with MS SQL SERVER. After migrating to CFMX and running the migration on first logon on CFMX admin, everything seemed to go to plan, then the errors started happening, SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed. The maximum simultaneous user count of 10 licenses for this 'Standard Edition' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version. This morning I scoured through the JDBC documentation and found that CFMX no longer uses the JDBC-ODBC bridge driver. All datasources had to be changed to ODBC SOCKETS. So while we were using MS SQL SERVER driver it was still connecting but must not have been releasing which is what may have been triggering this error. Anyway its just a bit confusing why the migration would not have taken care of this. J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
