You can run MySQL on a win box. Windows versions of MySQL require a license.
However, it is considerably less that SQL Server.
http://www.abriasoft.com/products11.php has a Win32 compiled version. The
standard version runs $109.00
One thing to consider with MySQL is that while it is supported on Linux and
NT/2000, the databases are not compatible. MySQL saves the databases as
files on the server. The files structure differences between Linux and
NT/2000 makes it "virtually" impossible to simply move the database from one
to the other. However, you could always create a new database on the one
being move to and do a query update.
You'll have to install the MySQL drivers on the NT/2000 box to use ODBC. CF
does not natively handle MySQL DSN setup through CF Administrator on the
NT/2000 platform, but you could create the datasources through the ODBC
manager on the server. I believe there my be a tag in the Allaire tag
gallery that will do this for you as well.
Additionally, you can use Access to create your structures on MySQL through
an ODBC connection. www.accessmysql.com ($30.00)
John Lucas
[EMAIL PROTECTED]
-----Original Message-----
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 22, 2001 2:58 PM
To: CF-Talk
Subject: Re: OT: Cheaper Alternative to SQL Server 2000
----- Original Message -----
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 7:03 PM
> You could look at MySql ->Free
Except for the fact if you are running NT/2000, you will need a seperate
machine
to run Linux/mySQL and which then costs the same as SQL Server for an
appropriate spec machine.
I agree that_if_you have a decent Linux box already - mySQL is a good
solution
for sure, but beyond that I am intrigued by the possibilities for MSDE -
anyone
tried that?
Adrian Cooper.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
