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:mwperry@xxxxxxxxxxx] Sent: Saturday, 2 October 2004 12:08 AM To: php-db@xxxxxxxxxxxxx Subject: 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 <mwperry@xxxxxxxxxxx> >> To: php-db@xxxxxxxxxxxxx >> Subject: 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
