Which one of these two scenarios would you find to be the most efficient use of the
ODBC connections on a CF server which connects to a SQL box? (we have a database on
a SQL server with 5 separate tables for different apps)
1. Multiple Datasource (one per app) names pointing to a single SQL database?
2. One datasource shared by all the apps connecting to the single SQL database?
If you have 15 users connecting at a time, which one leaves CF in the best shape? I
think that #2 is the best answer, but a Net Admin guy here asked and I wanted to be
sure.
Thanks.
Eric
Meagher & Geer, PLLP
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
