The following message is being posted for Libby Freligh, ColdFusion Product Manager, who for some reason was unable to do so herself (kept bouncing).
======================================================== I want to respond to the CONNECTSTRING comments. I know how useful this feature is and it was a difficult decision when we realized that we were not going to be able to support it in this release. The reason, as James points out, is that JDBC has no notion of CONNECTSTRING as ODBC does. In the CFMX Server product, we rely on the underlying application server engine (in this case JRun) to handle the datasource creation and it has no notion of dynamic calls to create connection pools on the fly. We went over a couple alternatives, like the one posted to the list, however they have inherent drawbacks. The most obvious drawback is that by making a direct connection, you bypass pooling and debugging capabilities, which is not a good option for most of our users (this option should work, btw, if it is appropriate for your app). We will continue to look into this issue to see if we can find a solution that gives you the functionality that you want and allows us to offer a supportable solution. l. -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 11:14 PM To: CF-Talk Subject: RE: Am I the only one who uses CONNECTSTRING ? (MX rant) Yes we use it everywhere. We generally use a shared host that provides one DSN per site. It's been nice to set up several databases on a site with no fuss, and no stuffing around with DSNs for local sites. Aside from losing that feature, it's a lot of queries to change. -----Original Message----- From: James Sleeman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 1 May 2002 2:56 p.m. To: CF-Talk Subject: Am I the only one who uses CONNECTSTRING ? (MX rant) Ok, now the NDA is moot I can ask the wider community. One of the best features IMHO in CF5 was the introduction of CONNECTSTRING to enable us to have dynamic datasources, that is, DSN-less connections. Since CF5 came out I have used these almost exclusively, infact I have been able to write applications that simply would not have been possible without it. But with the introduction of CF MX the CONNECTSTRING is now no more, at least in the initial release. This means we say goodbye to dynamic datasources and it's back to having to have every database set up individually by the CF administrator. This, in my opinion is a major step back, surely the purpose of a new release is to add features not take them away. The reason for losing the functionality appears to be to do with JDBC, and while it is possible to work around, Macromedia has basically said they don't have time to do it now so it's easier to sweep under the carpet and perhaps catch it next time - whenever that may be. This single issue is certainly going to stop me from using MX with any of my existing applications - the changes necessary would be widespread, and in some cases impossible. Indeed, for new applications I will have to evaluate thier needs carefully to determine if I can use MX or not. This is going to cause shared hosting providors to not be able to upgrade thier existing servers, at least not without imposing on thier clients to a great degree, it's also going to increase thier work load because now they must set up each and every database (can you imagine if 500 clients ask to have thier previously dynamic datasources set up all at once !). But, only a couple of people in the beta group aside form myself seem to be at all concerned about this. Am I the only one who uses CONNECTSTRING ? Surely it is such a useful feature that we can't release MX without it ? Surely it's worth working on for a little longer to get this functional ? Well, just had to get that off my chest, I'll go back to work now :-) --- James Sleeman ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists