freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Tareq <tarek.atallah AT tahadi.com>
- To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] freetds and php configiration
- Date: Mon, 26 Oct 2009 13:15:44 +0200
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] 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
-
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
-
[freetds] BCP/ISQL Trusted connection? [NC],
Cedric ROUVRAIS, 10/27/2009
- Re: [freetds] BCP/ISQL Trusted connection? [NC], James K. Lowden, 10/29/2009
-
Re: [freetds] freetds and php configiration,
Tareq, 10/26/2009
-
Re: [freetds] Is MS SQL Server closes cursor on every commit/rollback?,
Frediano Ziglio, 10/25/2009
Archive powered by MHonArc 2.6.24.