I don't know about "best" work around...but you could create 'links' to the other DB. This way you can use one DSN.
Doug >-----Original Message----- >From: Bosky, Dave [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 30, 2003 3:06 PM >To: CF-Talk >Subject: cftransaction : multiple datasources > > >What's the best work around for using multiple datasources in >cftransaction >tag? > >Dave > > > > >HTC Disclaimer: The information contained in this message may >be privileged and confidential and protected from disclosure. >If the reader of this message is not the intended recipient, >or an employee or agent responsible for delivering this >message to the intended recipient, you are hereby notified >that any dissemination, distribution or copying of this >communication is strictly prohibited. If you have received >this communication in error, please notify us immediately by >replying to the message and deleting it from your computer. Thank you. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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

