Chris Mead wrote: > I am mapping data sources via Windows ODBC and a trusted CF ODBC > socket to SQK2k but performance is slow relative to SQL authenticated > connects. The following tech note documents this: > http://www.macromedia.com/go/tn_18245. I am wondering if anyone is > using a different approach or 3rd party driver that would accommodate > a trusted connection and provide a faster connection. I am using > CFMX6.1 Standard (not j2ee) with 8/25/05 updater and all relevant > patches.
didn't one of the later hotfixes for cf6 & 7 provide updated datadirect drivers that added trusted authentication? not 100% sure but you might give jTDS driver a try, i seem to recall it might have trusted authentication as well (in any case it's a fast puppy). btw these are both jdbc drivers. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5457 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/10 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
