When licensing SQL Server (in M$'s new strategy) what matters is
authenticated vs non-authenticated users. As far as I understand it, and I
might be wrong, as long as your using the internet connector and your users
are connecting annonymously via your IISuser account you don't have to worry
too much about the licensing.
If on the otherhand you are using NT restrictions to authenticated users
that are allowed to make queries then you need the additional licences to
support them.
I might be completely offbase but this is what I gathered from a quick read
of the stuff.
hope this helps.
-----Original Message-----
From: Mark Woods [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 6:14 AM
To: CF-Server
Subject: RE: SQL Server Licensing Confusion -- and best alternative
IMHO, mySQL is only viable for minor applications, not necessarily because
of the time taken to learn how to use it (anyone who understands relational
database will pick in up in no time), but because it lacks support for
transactions or stored procedures (though sp support is planned for v4).
You should be able to use CFLOCK to lock access to the DB to a single
thread temporarily, effectively creating a transaction, but it's not going
to be as efficient as having transaction support built into the DBMS.
Mark
At 03:43 PM 3/3/2001, you wrote:
> MySQL will run on Linux, NT, or Solaris (MAC, DEC, FreeBSD, and
> AIX also I
>believe, but not positive). I'm sure someone in your company will know how
>to administer at least one of these. I've only used the NT version
>(comparison here:
>http://www.mysql.com/information/benchmark-results/result-mysql-platform-re
l
>ative.html) and I downloaded some of the free GUI's, and the interface was
>easy to use. Not to mention well documented on the web. There will be
some
>time learning it, but less than you think.
>
>-----Original Message-----
>From: Michiel Boland [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, March 03, 2001 7:32 AM
>To: CF-Server
>Subject: Re: SQL Server Licensing Confusion -- and best alternative
>
>
> > MYSQL. The most used database in the world. It will work for up to 100
> > Gig. The most it could possibly cost you for a single implementation is
> > $200.00. In all likelihood it is free. -Tom
>
>You are forgetting the time (=money) it takes to train people to work with
>and support MySQL, and the systems on which the database is hosted.
>
>Cheers
>Michiel
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
