Bryan: Licensing is a bit tricky. You can use here when you have a license for X, but you can't distribute it. You can distribute it if you have license for X & Y. Best thing I have found is the following link (watch for the wrap):
http://www.microsoft.com/sql/msde/howtobuy/default.asp Yes, for smaller applications it works well. We primarily use it when we intergate with Microsoft's Retail Management software which uses MSDE as the database engine. There is a thread limit and database size limit as well. Can't remember off the top of my head but I am sure you will find the necessary info on their website. Also, in regards to hosting, I have not seen any ISP's off the top of my head. We host our own sites we build for our clients and run an instance of SQL2K and MSDE on the same database server. Runs well and with little extra overhead (granted there are only two MSDE databases at the moment compared to 17 on SQL2K). Good luck, -JSLucido -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, August 25, 2003 11:08 AM To: CF-Talk Subject: Re: RE: MS SQL Server vs. MySQL Hey Jeff, Great...thanks for the info. I'm certainly starting to think that MSDE will be a great alternative for our smaller clients. Now it sounds like it's totally free?? any licenceing issues? Does anybody know of ISPs that will host MSDE DBs? or is generally used for apps running co-lo or dedicated servers? TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Jeff Lucido" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 9:02 AM Subject: RE: RE: MS SQL Server vs. MySQL > Bryan: > > 1. Yes, I use Enterprise Manager to connect to several MSDE databases > running at client locations. 2. Yes, MSDE can be found on both the > Office 2K and XP Professional CD's. You can also download a new > instance by downloading MSDE SP3 from Microsoft. I just did it as a > test this past week where I had no previous install of MSDE and I ran > MSDE SP3 and it installed a brand-new instance for me. > > Hope that helps! > > Good luck, > -JSLucido > > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Monday, August 25, 2003 10:44 AM > To: CF-Talk > Subject: Re: RE: MS SQL Server vs. MySQL > > > Just wondering from those that use MSDE.... > > 1) Can Enterprise Manager from a licenced copy of MS SQL Server > connect to a remote MSDE DB? > > 2) Can you get MSDE seperate from the Standard or Enterprise versions > of MS SQL Server (because the MS site seems to say it comes with...in > which case a client would have to cough up full price for a full-blown > version = no benefit)? > > TIA > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "Josh Remus" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, August 22, 2003 12:09 PM > Subject: RE: RE: MS SQL Server vs. MySQL > > > > It does include osql if you just need shell-type/command-prompt SQL > access. > > We have licenses for SQL Server, so I do use Enterprise Manager to > > manage our MSDE databases. > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 22, 2003 1:49 PM > > > To: CF-Talk > > > Subject: Re: RE: MS SQL Server vs. MySQL > > > > > > > > > but to > > > > get the 2k version, you need either MSDN, Sql server 2k, or > > > > Office > > > > > XP. > > > > > > Yeah, it looks that way now. Funny, I went to their site a couple > > > of months ago and downloaded from there. Those wacky MS guys. > > > > > > One thing: MSDE comes with no front end tools, so you'll need > > > either the client tools from Enterprise Manager, or Access, or a > > > third party front end. One might be better off getting a > > > developer license for SQL Server, which is now only $49. There > > > was a thread about it a while ago. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
