I got a response from Microsoft to my comments on the difference between Oracle and SQL Server pricing. I should point out that neither MS (NZ) nor the two resellers we approached knew of this. Here it is: ----------------------------------------------------------------------------------------------------- A comment that you made on the Delphi Users Group about SQL Server licensing was forwarded to me for comment: Cant help with Informix, but for Oracle I would add the warning not to try this without a DBA. Oracle Lite is seriously chopped down - no PL/SQL so no triggers, stored procs etc at all. Oracle Workgroup (or standard Oracle is around $700 a licence, Enterprise is more like $2000). A very important distinction between SQL server and Oracle on licensing what is actually licensed. With SQL Server you have to license every client that will connect to it. With Oracle you license by connection, so it only maximum no. of simultaneous connections that has to be licensed. Read your SQL server license document VERY CAREFULLY if you are connecting it to the web... This is one of the modes that you can license SQL Server in. We call this "Per Seat" licensing. Alternatively you can license SQL Server in "Per Server" mode... which gives you the concurrency that you mention on the Oracle line. More information can be found at http://www.microsoft.com/enterprise/licensing/BackOffice.htm <http://www.microsoft.com/enterprise/licensing/BackOffice.htm> For Internet use we sell an Internet license for SQL Server Connections. ---------------------------------------------------------- Phil Scadden, Institute of Geological and Nuclear Sciences PO Box 30368, Lower Hutt, New Zealand Ph +64 4 5704821, fax +64 4 5704603 --------------------------------------------------------------------------- New Zealand Delphi Users group - Database List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
