Re: freetds and php configiration

Robert Gonzalez <[email protected]> Mon, 26 Oct 2009 09:18:10 -0700
Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<[email protected]>
The following are two write-ups I did on getting PHP to talk to MS SQL
servers from Fedora and from Ubuntu. Both of these use the native MS SQL
extension for PHP (which in my opinion is way better than using ODBC). Keep
in mind these instructions assume you have control over your own server and
that you have some experience building software, specifically PHP
extensions, from source.

http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/
<http://www.robert-gonzalez.com/2009/02/18/building-the-php-ms-sql-server-extension-from-source-on-ubuntu-810/>
http://www.robert-gonzalez.com/2008/03/31/connecting-php-on-linux-to-mssql-on-windows/

On Mon, Oct 26, 2009 at 7:41 AM, Per Stenebo <[email protected]> wrote:

> It would be nice to be able to use mssql extension with php and freetds but
> I have not yet figured out how.
> In my very limited knowledge I can use only ODBC extension.
> /Per Stenebo
>
> 2009/10/26 Tareq <[email protected]>
>
> > I was wondering cant we use mssql php extension to do so ?
> >
> >
> >
> >
> > Tarek Atallah
> > Senior Database Administrator
> > Tahadi Games - www.tahadi.com
> > Mobile +962 776555508
> > E-mail W : [email protected]
> > E-mail P  : [email protected]
> >
> >
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]] On Behalf Of Per Stenebo
> > Sent: Monday, October 26, 2009 2:01 PM
> > To: FreeTDS Development Group
> > Subject: Re: [freetds] freetds and php configiration
> >
> > This is a test script I've been using to connect to a MS SQLserver 2005
> > thru
> > PHP and FreeTDS:
> > It simply connects and list user tables in the DB.
> >
> > <html>
> > <body>
> >
> > <?php
> > $db = "mydatabase";
> >
> >  $con = odbc_connect("databaseserver", "domain\\username", "password");
> >  if (!$con)
> >    {
> >        print("There is a problem with SQL Server connection.\n");
> >      }
> >  else
> >    {
> >        print("The SQL Server connection object is ready.\n");
> >
> > // List user tables in database
> >        echo "<h4>Tables in database $db</h4>";
> >        $sql = "select name from $db..sysobjects where xtype = 'U'";
> >        $result = odbc_exec($con, $sql) or die(odbc_errormsg($con));
> >        while (odbc_fetch_row($result))
> >            {
> >                print("<p>" . odbc_result($result,1) . "</p>\n");
> >            }
> >
> >        odbc_free_result($result);
> >        odbc_close($con);
> >    }
> > ?>
> >
> >
> > </body>
> > </html>
> >
> > I think the keywords to use in searching for help are "php ODBC".
> > Hope it helps.
> > /Per Stenebo
> >
> >
> > 2009/10/26 Tareq <[email protected]>
> >
> > > Hi all ,
> > >
> > > I have installed  freetds and php, now how I can configure php to use
> > tds?
> > >
> > > Any help please?
> > >
> > >
> > >
> > >
> > > Tarek Atallah
> > > Senior Database Administrator
> > > Tahadi Games - www.tahadi.com
> > > Mobile +962 776555508
> > > E-mail W : [email protected]
> > > E-mail P  : [email protected]
> > >
> > >
> > > -----Original Message-----
> > > From: [email protected]
> > > [mailto:[email protected]] On Behalf Of Frediano
> Ziglio
> > > Sent: Sunday, October 25, 2009 10:41 AM
> > > To: [email protected]; FreeTDS Development Group
> > > Subject: Re: [freetds] Is MS SQL Server closes cursor on every
> > > commit/rollback?
> > >
> > > This is a server setting. Do you really need to use this option?
> > >
> > > freddy77
> > >
> > > Il giorno 25/ott/2009, alle ore 09.08, [email protected] ha
> scritto:
> > >
> > > > Hi, ALL,
> > > > I am trying to develop a program that will
> > > > use an ODBC connection to different DB.
> > > > It will be based on some other C++ library.
> > > >
> > > > What I found is that the comment to the ODBC interface
> > > > for this library says following:
> > > >
> > > > // By default, MS Sql Server closes cursors on commit and rollback.
> > > > The following
> > > > // call to SQLSetConnectOption() is needed to force SQL Server to
> > > > preserve cursors
> > > > // after a transaction.  This is a driver specific option and is not
> > > > part of the
> > > > // ODBC standard.  Note: this behavior is specific to the ODBC
> > > > interface to SQL Server.
> > > > // The database settings don't have any effect one way or the other.
> > > > const long SQL_PRESERVE_CURSORS = 1204L;
> > > > const long SQL_PC_ON = 1L;
> > > > /* retcode = */ SQLSetConnectOption(hdbc, SQL_PRESERVE_CURSORS,
> > > > SQL_PC_ON);
> > > >
> > > > Is this true for all version of MS SQL Server or just for an old
> ones?
> > > > Is it the same for Sybase as well?
> > > >
> > > > What I will gain/lose when this will be disabled?
> > > >
> > > > Thank you.
> > > >
> > > > _______________________________________________
> > > > FreeTDS mailing list
> > > > [email protected]
> > > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > > _______________________________________________
> > > FreeTDS mailing list
> > > [email protected]
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> > > _______________________________________________
> > > FreeTDS mailing list
> > > [email protected]
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > >
> >
> >
> >
> > --
> > MVH Per Stenebo
> > Ballingslöv
> > 0708-78 18 24
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> > _______________________________________________
> > FreeTDS mailing list
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
>
> --
> MVH Per Stenebo
> Ballingslöv
> 0708-78 18 24
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 

Robert Gonzalez
http://www.robert-gonzalez.com