My employer currently has the typical data management scenario of six or seven Access databases that don't talk to each other, etc. etc. etc. You all know the drill! I am in the midst of drawing up a proposal that involves moving all of the data to a truly relational SQL Server environment. I will then develop the user interface in ColdFusion. Note this is strictly an intranet application. My question has to do with the theories behind separating the web server from the database server. As I write up this proposal, should I recommend a separate server for each? What is the rationale? I presume it has to do with the relatively poor security of a web server vs the much improved security of a database server? (note: WIN2K Server/SQL Server) All of my ColdFusion development to date has been with the database on the web sever. What connectivity issues am I facing with a separation? Does protocol dictate the creation of a user account specifically for the CF server to establish a secure connection to the DB Server? Will the separation prohibit me from using things like FileExists? Will I need Administrative rights on BOTH machines? Also, can someone direct me to an write up about ColdFusion that is directed toward non-technical people? I need to "sell" ColdFusion to management and want to read some other people's "explanations" to round out my sales pitch. You see, managment is concerned that if I leave the company they will be left high and dry with a "non-standard" ColdFusion environment. My argument is that CF is so intuitive that finding a person capable of maintaining a CF application will probably be easier than a comparable ASP or PHP approach. Am I off base? If you are of the opinion that this type of subject matter is out of the scope of this list, please feel free to correspond via email if you feel you want to help me understand this. Thanks in advance [EMAIL PROTECTED]
********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete. it. Thank you, ViaHealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
