freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] freetds and php configiration

From: Per Stenebo <per AT bends.se>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] freetds and php configiration
Date: Mon, 26 Oct 2009 15:41:39 +0100

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 <tarek.atallah AT tahadi.com>

> 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 : tarek.atallah AT tahadi.com
> E-mail P : tarek.atallah AT gmail.com
>
>
> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] 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 <tarek.atallah AT tahadi.com>
>
> > 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 : tarek.atallah AT tahadi.com
> > E-mail P : tarek.atallah AT gmail.com
> >
> >
> > -----Original Message-----
> > From: freetds-bounces AT lists.ibiblio.org
> > [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Frediano Ziglio
> > Sent: Sunday, October 25, 2009 10:41 AM
> > To: ikorot AT earthlink.net; 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, ikorot AT earthlink.net 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
> > > FreeTDS AT lists.ibiblio.org
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
>
>
>
> --
> MVH Per Stenebo
> Ballingslöv
> 0708-78 18 24
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

--
MVH Per Stenebo
Ballingslöv
0708-78 18 24

[freetds] Is MS SQL Server closes cursor on every commit/rollback?, ikorot, 10/25/2009
- Re: [freetds] Is MS SQL Server closes cursor on every commit/rollback?, Frediano Ziglio, 10/25/2009
  - Re: [freetds] freetds and php configiration, Tareq, 10/26/2009
    - Re: [freetds] freetds and php configiration, Per Stenebo, 10/26/2009
      - Re: [freetds] freetds and php configiration, Tareq, 10/26/2009
        
        Re: [freetds] freetds and php configiration, Per Stenebo, 10/26/2009
        
        Re: [freetds] freetds and php configiration, Robert Gonzalez, 10/26/2009
  - [freetds] BCP/ISQL Trusted connection? [NC], Cedric ROUVRAIS, 10/27/2009
    - Re: [freetds] BCP/ISQL Trusted connection? [NC], James K. Lowden, 10/29/2009