> Nice. So it's only possible with MySQL and MS SQL Server > data sources? I > don't know what DB Simmyana is using but the one I > mentioned was SQL server.
Iirc, with MS Access if you place multiple db's in the same directory, you can reference them in queries to any of them the way that you can reference different catalogs in MySQL, i.e. users.mdb content.mdb store.mdb users.mdb - select * from store.product I don't condone the use of MS Access personally, I've just seen that done. At least I remember seeing that done. I'm pretty sure Oracle also provides the same capabilities, although technically more often than not (or maybe always) oracle db's swap out the schema (user) rather than swapping out the catalog (database). We use SQL Server where I work now -- it's handy to be able to use a single CF DSN for all our projects, that way we don't have to clutter up our CF admin every time we add a new client project. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206082 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
