RE: mySQL vs. Access or MSDE (worm note)
> What about Access 2002? Does it include MSDE and does it > listen on port 1433 as a default? MSDE is a separate install, I'd guess, rather than part of the standard Access 2002 install. > I was thinking what kind of SQL Admin in their right mind > would leave the sa password blank ... For production databases, not very many. However, considering that there are probably a hundred developers running a local copy for each production database server out there, I'd guess that there are a high percentage of installs with blank passwords. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
RE: mySQL vs. Access
> > mySQL, hands down. With the right GUI front end you also have an easy > and very powerful environment to work in. The free/donationware > mySQLFront (http://www.mysqlfront.de) is my favorite. > Thanks for the tip-- this is definitely the best Windoze MySQL front-end I've used. I've been using MyCC for close to a year, and its super quirky. I've been using it with in combination with phpMyAdmin to get past its shortcomings. I just used the "Export Tables" tool in MySQL-Front to move data from one database to another, and it worked flawlessly. If you didn't know it already, phpMyAdmin is an awesome web-based front-end for MySQL. I love the command line, but its just not a sufficient tool for managing a database. (I use MySQL on Linux and FreeBSD) As far as MySQL vs. Access, it will certainly take more time to configure and learn MySQL, but you'll be glad you did in the long run. Downloading the above GUI will make it very simple to work with once you get it setup. IMHO, if you need a book, the best MySQL book is MySQL by Paul DuBois. Personally, I think anyone having problems with Access that can't afford MS SQL Server should really consider moving to MySQL. - Brandon -- http://spooled.net http://booms.net 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
RE: mySQL vs. Access or MSDE (worm note)
The easiest way to avoid this is to close port 1433 in the firewall except from relevant IP addresses. We only allow connections from our office and if someone is offsite they have to either tunnel into the production environment or tunnel into the office to access the SQL servers. I would never leave critical services exposed from any WAN IP. Justin > -Original Message- > From: Jon Hall [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 8:30 PM > To: CF-Talk > Subject: Re: mySQL vs. Access or MSDE (worm note) > > What about Access 2002? Does it include MSDE and does it > listen on port 1433 > as a default? We started to see a lot of invalid logins to > our SQL Servers > last night I was thinking what kind of SQL Admin in their > right mind > would leave the sa password blank, certainly there can't be that many > irresponsible SQL Admins out there, but if these are MSDE > installations > getting infected it makes more sense > > jon > - Original Message - > From: "chad" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, May 21, 2002 5:23 PM > Subject: RE: mySQL vs. Access or MSDE (worm note) > > > > I should have mentioned it in my last post about the MS SQL worm. > > > > Starting with Access 2000, Microsoft began to ship a > stripped down version > > of SQL Server called Microsoft SQLServer Desktop Edition > (MSDE). It was > not > > installed by default in an Access 2000 install, but was > available as an > > add-on on the installation disks. If installed, no password > is set for the > > SA account. > > > > > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
Re: mySQL vs. Access or MSDE (worm note)
What about Access 2002? Does it include MSDE and does it listen on port 1433 as a default? We started to see a lot of invalid logins to our SQL Servers last night I was thinking what kind of SQL Admin in their right mind would leave the sa password blank, certainly there can't be that many irresponsible SQL Admins out there, but if these are MSDE installations getting infected it makes more sense jon - Original Message - From: "chad" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 5:23 PM Subject: RE: mySQL vs. Access or MSDE (worm note) > I should have mentioned it in my last post about the MS SQL worm. > > Starting with Access 2000, Microsoft began to ship a stripped down version > of SQL Server called Microsoft SQLServer Desktop Edition (MSDE). It was not > installed by default in an Access 2000 install, but was available as an > add-on on the installation disks. If installed, no password is set for the > SA account. > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access or MSDE
> there are probably some limitations from a licensing > perspective, but I don't know what those limitations are. References at MSDN pointed to needing Office Developer or Visual Studio, but didn't say so outright. Called MS and asked whether my copy of Office XP Pro, which contains MSDE, could be used to put MSDE on a commercial, production web server. After some checking the answer came back as ''yes''. If you have anything with an installable MSDE on it you can use that on a web server, as MSDE is redistributable by anyone with an installable copy. Vewwwy intewesting. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: mySQL vs. Access or MSDE
> I (mistakenly?) understood it only worked in a 'desktop' > environment, running in the background of, say a VB app. > Is that wrong? No, it'll work fine with CF apps. It's SQL Server, with some limitations on maximum data size and concurrent connections, and no Enterprise Manager. Macromedia has used this in the past for some of their CF courseware, instead of Access. As Matt Robertson noted, there are probably some limitations from a licensing perspective, but I don't know what those limitations are. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: mySQL vs. Access or MSDE
> -Original Message- > From: Craig Thomas [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 5:25 PM > To: CF-Talk > Subject: RE: mySQL vs. Access or MSDE > > > >>> Anyone have a feeling about the Microsoft Data Engine, which > > is supposed to be a limited connection version of SQL that > > can upscale to SQL very easily rather than Access? > > It is SQL Server, essentially, with some minor limitations. I've > worked with > it quite a bit, and like it for use instead of Access.<< > > I (mistakenly?) understood it only worked in a 'desktop' environment, > running in the background of, say a VB app. Is that wrong? It runs on Windows 2000 Server as well, and handles concurrency a lot better than Access. I work and have worked with it on past projects and it's so nice to be able to develop on my full-blown development server with SQL Server 2000 and port it over to MSDE. Sure, that might be backwards somewhat, but cost-wise clients like it much better when they have low-hit sites, since it's a true database server. You just have to make sure they understand that it won't handle high load like the full application. Porting your database(s) to and from MSDE is quite painless, in my experience. --Andy __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access or MSDE
Somewhere in the MS KB (which so far I can't find) I read that you need to be an owner of the MS Office Developer Edition in order to legally deploy MSDE on a web server. Everything I've found so far makes no mention of this. --- Matt Robertson[EMAIL PROTECTED] MSB Designs, Inc., www.mysecretbase.com --- -- Original Message -- from: "Craig Thomas" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Tue, 21 May 2002 17:25:25 -0400 >>> Anyone have a feeling about the Microsoft Data Engine, which > is supposed to be a limited connection version of SQL that > can upscale to SQL very easily rather than Access? It is SQL Server, essentially, with some minor limitations. I've worked with it quite a bit, and like it for use instead of Access.<< I (mistakenly?) understood it only worked in a 'desktop' environment, running in the background of, say a VB app. Is that wrong? -Craig Thomas __ 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
RE: mySQL vs. Access or MSDE (worm note)
I should have mentioned it in my last post about the MS SQL worm. Starting with Access 2000, Microsoft began to ship a stripped down version of SQL Server called Microsoft SQLServer Desktop Edition (MSDE). It was not installed by default in an Access 2000 install, but was available as an add-on on the installation disks. If installed, no password is set for the SA account. At 05:25 PM 5/21/2002 -0400, you wrote: > >>> Anyone have a feeling about the Microsoft Data Engine, which > > is supposed to be a limited connection version of SQL that > > can upscale to SQL very easily rather than Access? > >It is SQL Server, essentially, with some minor limitations. I've worked with >it quite a bit, and like it for use instead of Access.<< > >I (mistakenly?) understood it only worked in a 'desktop' environment, >running in the background of, say a VB app. Is that wrong? > >-Craig Thomas > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: mySQL vs. Access or MSDE
>>> Anyone have a feeling about the Microsoft Data Engine, which > is supposed to be a limited connection version of SQL that > can upscale to SQL very easily rather than Access? It is SQL Server, essentially, with some minor limitations. I've worked with it quite a bit, and like it for use instead of Access.<< I (mistakenly?) understood it only worked in a 'desktop' environment, running in the background of, say a VB app. Is that wrong? -Craig Thomas __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
RE: mySQL vs. Access or MSDE
That is what I thought. I have not understood why people do not go this way instead of using Access... seems like a better solution in terms future scalability if one is looking to eventually move SQL Server. Justin > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 5:14 PM > To: CF-Talk > Subject: RE: mySQL vs. Access or MSDE > > Anyone have a feeling about the Microsoft Data Engine, which > > is supposed to be a limited connection version of SQL that > > can upscale to SQL very easily rather than Access? > > It is SQL Server, essentially, with some minor limitations. > I've worked with > it quite a bit, and like it for use instead of Access. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access or MSDE
> Anyone have a feeling about the Microsoft Data Engine, which > is supposed to be a limited connection version of SQL that > can upscale to SQL very easily rather than Access? It is SQL Server, essentially, with some minor limitations. I've worked with it quite a bit, and like it for use instead of Access. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: mySQL vs. Access or MSDE
Anyone have a feeling about the Microsoft Data Engine, which is supposed to be a limited connection version of SQL that can upscale to SQL very easily rather than Access? Justin > -Original Message- > From: Bosky, Dave [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 9:15 AM > To: CF-Talk > Subject: mySQL vs. Access > > > Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? > > Thanks, > Dave > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
Re: mySQL vs. Access
It seems odd that MSDE wan't included in this thread. It seems to be a decent alternative to Access. Maybe there are problems with it that I haven't bumped into yet? > mySQL, hands down. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: mySQL vs. Access
In the previous post, the poster changed mySQL to msSQL, which would definitely change the cost/ease ratio! Jerry Johnson >>> [EMAIL PROTECTED] 05/21/02 11:49AM >>> >>If we're talking SMALL small and software licencing is a concern, then Access will do the job as well<< What type of licensing concern would dictate Access over mySql? I would use mySql over access any day. -Craig Thomas __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: mySQL vs. Access
Just as good as Enterprise Manager and a lot cheaper! Thanks, Dave Bosky -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 1:23 PM To: CF-Talk Subject: RE: mySQL vs. Access I'm just as happy with it. Totally simplifies db management. Make sure you check out logging into multiple db's (on multiple machines) at once, then export/import between them. That one's worth its weight in gold, IMHO. --Matt-- -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:15 AM To: CF-Talk Subject: RE: mySQL vs. Access Thanks Matt! The mySQL interface is excellent! I was doing it from the command line when I started and this is much easier! Thanks, Dave Bosky __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: mySQL vs. Access
I'm just as happy with it. Totally simplifies db management. Make sure you check out logging into multiple db's (on multiple machines) at once, then export/import between them. That one's worth its weight in gold, IMHO. --Matt-- -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 10:15 AM To: CF-Talk Subject: RE: mySQL vs. Access Thanks Matt! The mySQL interface is excellent! I was doing it from the command line when I started and this is much easier! Thanks, Dave Bosky __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: mySQL vs. Access
Jeppers use mysql if you are about access is evil.. A wise man named adam once told me ;) FRiends dont let friends use access Bill Wheatley Senior Database Developer Macromedia Certified Advanced Coldfusion Developer EDIETS.COM 954.360.9022 X159 ICQ 417645 - Original Message - From: "Bosky, Dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 21, 2002 9:15 AM Subject: mySQL vs. Access > Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? > > Thanks, > Dave > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access
Thanks Matt! The mySQL interface is excellent! I was doing it from the command line when I started and this is much easier! Thanks, Dave Bosky -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 12:30 PM To: CF-Talk Subject: RE: mySQL vs. Access mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 6:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access
> Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? OK, here's a simple rule of thumb: mySQL (or msSQL ) is a Server app, so it should be used on servers Access is a Desktop app, so it should be used on a desktop As long as you can GUARANTEE that the traffic is very low, then Access will do, but it has HUGE Jet Engine problems, and horrible memory leaks - DO NOT use it in a live environment that you expect to get some real traffic to (Intranet or Internet) It's probably better to use mySQL anyways as if you ever have to upgrade the number of users, then you don't have to do anything - with Access you'd have to re-write to get it working with a real database engine once you increase the number of users Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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 notify the system manager. ** __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
RE: mySQL vs. Access
If you are looking for ease of use, go with Access. Much easier to use than MySQL. -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:30 AM To: CF-Talk Subject: RE: mySQL vs. Access mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 6:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access
Good Grief! *brews more coffee* mySQL mySQL mySQL... For some stupid reason, I read it as "Access vs MS SQL". :/ By all means use mySQL over Access... every day of the week and twice on Sunday. :) -Original Message- From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:51 AM To: CF-Talk Subject: FW: mySQL vs. Access I mean mySQL! *looking for coffee cup* -Original Message- From: Hoag, Claudia (LNG) Sent: Tuesday, May 21, 2002 11:50 AM To: '[EMAIL PROTECTED]' Subject: RE: mySQL vs. Access Hm, if we're talking SMALL small then I would think you don't have to pay anything to use msSQL, right? -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: RE: mySQL vs. Access If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. > Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? > > Thanks, > Dave > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
RE: mySQL vs. Access
mySQL, hands down. With the right GUI front end you also have an easy and very powerful environment to work in. The free/donationware mySQLFront (http://www.mysqlfront.de) is my favorite. --Matt Robertson-- MSB Designs, Inc. http://mysecretbase.com -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 6:15 AM To: CF-Talk Subject: mySQL vs. Access Which database would be better to use for a small Intranet with a few updatable pages, mySQL or Access? Any experiences using one over another? What about ease of use? Thanks, Dave __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: mySQL vs. Access
Hm, if we're talking SMALL small then I would think you don't have to pay anything to use msSQL, right? -Original Message- From: Carlisle, Eric [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:34 AM To: CF-Talk Subject: RE: mySQL vs. Access If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. > Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? > > Thanks, > Dave > > > > __ 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
RE: mySQL vs. Access
In Access you can create a date/time field and create the ODBC datetime with a cf variable and check against that. __ >This list and all House of Fusion resources hosted by CFHosting.com. The >place for dependable ColdFusion Hosting. >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 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
RE: mySQL vs. Access
>>If we're talking SMALL small and software licencing is a concern, then Access will do the job as well<< What type of licensing concern would dictate Access over mySql? I would use mySql over access any day. -Craig Thomas __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: mySQL vs. Access
I prefer mySQL for intranets. Intranets, by definition, will be used by multiple people. The largest problem with Access is its inability to handle multiple concurrent users. If you have fears of using mySQL and prefer the GUI of Access you can buy myAccess for about $20. It essentially allows developers unfamiliar with mySQL to create and work in Access and then port it over to mySQL, data inclusive. As personal opinion goes, I find mySQL to be the best suited DB for my needs. You can directly telnet into the DB server from any remote location as long as the sys admins have given you access. It seems odd, but the mySQL community is very much like the CF community in that they are always willing to help and consists of a lot of very knowledgeable developers. Can't beat the price either! I've extensively used FoxPro, Access, MS SQL Server, Oracle, and MySQL. Of those, I can only seriously recommend MS SQL, Oracle and MySQL for any web application. Of the 3 mySQL is a happy medium. The learning curve and power is between MS SQL and Oracle. It lacks certain things such as subselects and transactions. Sub-selects are easily circumvented by using outer joins and due to the inherent speed advantage it enjoys over MS SQL my informal tests show that outer joins are faster on mySQL then sub-selects on SQL server. At 09:15 AM 5/21/2002 -0400, you wrote: >Which database would be better to use for a small Intranet with a few >updatable pages, mySQL or Access? >Any experiences using one over another? What about ease of use? > >Thanks, >Dave > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
RE: mySQL vs. Access
If we're talking SMALL small and software licencing is a concern, then Access will do the job as well. msSQL is preferable if budget permits, but Access is an ok substitute if there are fewer requests, smaller tables, etc... Eric -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 11:24 AM To: CF-Talk Subject: Re: mySQL vs. Access My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. > Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? > > Thanks, > Dave > > > > __ Get the mailserver that powers this list at http://www.coolfusion.com 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
Re: mySQL vs. Access
My opinion is to use MySQL as it is much faster and more robust than Access. I use MySQL for all my small stuff. HTH -- Clint Tredway -- Through Him, anything is possible. > Which database would be better to use for a small Intranet with a few > updatable pages, mySQL or Access? > Any experiences using one over another? What about ease of use? > > Thanks, > Dave > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
