There are many facters that have to be considered to make a proper decision. First, as you have stated, mssql offers many features not available in mysql. If these featuers are important, then you should choose mssql. However, PHP's support for mysql is much better than its support for mssql. PHP's "out of the box" support for mssql is limited and inconsistent accross platforms. In fact, its support is much better on non-Win32 machines than it is on Win32 machines. This is not surprising since it relies on DB-Library for WIn32 systems, and FreeTDS for non-Win32 systems.
-- bob On Fri, 1 Oct 2004, Matthew Perry wrote: > 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=http://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