JB Cameron wrote: > We are looking to optimize performance for a few client sites and many > optimization whitepapers have recommended using a Type IV JDBC driver for > MS-SQL server. What driver type of driver comes pre-built with with CFMX 7.0?
cf already has a type 4 from data direct for sql server, labeled as "Microsoft SQL Server" in the drivers pull-down in cfadmin/dsn. don't use the ODBC driver (actually a bridge as cf is java & "talks" to the db via jdbc) as it's slower & not unicode compliant. if you want speed, might give jTDS a spin. it's *fast*. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307145 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
