> I recently switched to using the latest Microsoft JDBC Driver for > MSSQL 2005 > and immediately saw a performance increase (over using the standard > driver > w/ ColdFusion 8.01). However, all our queries that have multiple > statements > are failing so I've had to switch back. e.g.
I know with MySQL, you can specify multiple queries right in your DSN setting. http://www.bennadel.com/blog/1542-MySQL-3-4-com-mysql-jdbc-Driver-And-allowMultiQueries-true.htm I don't know if there's an equivalent for the SQL Server driver. Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
