Matthew,

Take a close look at Sybase 12.5.2 Express Edition -
http://www.sybase.com/linuxpromo

They have released the latest version of their flagship database as a
royalty free Linux implementation.

There are constraints being 1 CPU*, 2 Gb RAM and 5 Gb Data.  If your
application can live within these limitations you can use it in production
for free.  You can even purchase support on it (not cheap though)!

IMO the only serious constraint is the 5 Gb Data limit.  You would need a
very busy TP or DSS system to push beyond the other limits, by which time
you should be able to fund the licencing of the full product.

I am using Sybase Developer Edition (same code base) with the ct libraries
and PHP 4.3.8 no problems.  The only downside at the moment is the version
of Linux - at the moment it is only certified for RH AS 2 and 3, SuSE ES 9.0
(plus a few others) but there appears to be ways of running it on Fedora
Core.  I am using RH 7.3 because 7.2 was the last free distro identified and
I had it handy.

Zap me a mail if you need more info - news sites etc.

Cheers,
Frank.


* 1 CPU for the dataserver - you can run it on a multi cpu system with more
than 2 Gb RAM.  In a dual CPU host use 1 CPU for Data and one for
Apache/PHP.

-----Original Message-----
From: Matthew Perry [mailto:[EMAIL PROTECTED]
Sent: Saturday, 2 October 2004 12:08 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] which DB to use?


Thank you very much for your help.
If I had to choose between MS SQL Server or or mysql, which would you
recommend?  I prefer nested subqueries, triggers, procedures etc
supported by SQL Server but am completely unfamiliar with any problems
that may be accociated with using Microsoft's product and PHP.

Ideally, I would use Oracle but it is probably outside of our budget.

- matt



Bastien Koert wrote:

> Here is a basic connect script. I would stringly recommend against
> using access, use mysql instead.
>
> <HTML>
>  <HEAD>
>  </HEAD>
>
>  <BODY>
>
>    <?php
>
>      // Program to test connecting to a Microsoft Access ODBC Data Source
>      $connection = odbc_connect("postcard", "", "");
>      print "Connected to datasource<BR><BR>";
>
>      if ($result = odbc_exec($connection, "SELECT * FROM postcard"))
>        print "Command executed successfully<BR><BR>";
>      else
>        print "Error while executing command<BR><BR>";
>
>      // Print results
>      while(odbc_fetch_row($result))
>        print odbc_result($result, 1) . "   " . odbc_result($result, 2)
> . "   " . odbc_result($result, 3) . "   " . odbc_result($result, 4) .
> "   " . odbc_result($result, 5) . "<BR>";
>
>      odbc_close($connection);
>      print "<BR>Connection closed.";
>
>    ?>
>
>  </BODY>
> </HTML>
>
> bastien
>
>
>> From: Matthew Perry <[EMAIL PROTECTED]>
>> To: [EMAIL PROTECTED]
>> Subject: [PHP-DB] microsoft access
>> Date: Thu, 30 Sep 2004 21:28:48 -0500
>>
>> Does anyone know of a good online source for using php and microsoft
>> access. I don't want to have to use asp.
>> Thank you for your time.
>>
>> Matthew Perry
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
> _________________________________________________________________
> MSNŽ Calendar keeps you organized and takes the effort out of
> scheduling get-togethers.
>
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt
p://hotmail.com/enca&HL=Market_MSNIS_Taglines
>  Start enjoying all the benefits of MSNŽ Premium right now and get the
> first two months FREE*.
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to