> Hello all > > > We are looking into upgrading to CFMX from CF5, but one > issue we have not been able to overcome is that CFMX does not > have DSNless db connections. Is there a way in CFMX to create > a DSN connection on the fly, i.e. not having to go to CF > Admin to create the mapping? > > Currently we have engineers that go all over the world > (Europe, Japan, Korea, etc), so they some times have very limited > access to GOOD internet access. > > SO, We have developed an MS ACCESS db application that they > take a copy of, with them to what every site they are going to survey. > > Upon returning they upload the db to the website. > > Currently the db is renamed at upload to conform to the > surveyed sites naming convention and the db dir is saved to > table on the server(central db) and later this is pulled to > create the DSNless connection to access the uploaded db, for > displaying info on the website. > > Is there a way in CFMX to create the DSN connection when the > db is uploaded? Hope I have explained this enough.
It may not be fast, but you should be able to use COM/ADO to create your connections (I'm assuming you're on windows since you're using Access). You should be able to dig up information at www.cfcomet.com. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4