[freetds] Freetds PHP problem

Kelley, Peter Peter at radiator.com
Wed Sep 8 13:39:23 EDT 2004


I recently built a new server (RedHat ES 3.0) upgrading Freetds from version
0.61.2 to version 0.62.4.  I'm using Freetds with PHP, and the PHP version
remains the same at 4.3.4.

After upgrading, accessing MSSQL Server from PHP, the connection settings
changed.  Specifically ansi_nulls and ansi_warnings were no longer set.

Checking connection settings:
DBCC USEROPTIONS
FROM PHP 4.3.4/Freetds 0.62.4 ansi_nulls and ansi_warnings NOT set
FROM PHP 4.3.4/Freetds 0.61.2 ansi_nulls and ansi_warnings set

FROM tsql, Freetds 0.62.4 ansi_nulls and ansi_warnings set
FROM tsqsl, Freetds 0.61.2 ansi_nulls and ansi_warnings set

Why did the connection settings change when upgrading to
PHP4.3.4/Freetds-0.62.4 from PHP4.3.4/freetds-0.61.2?
Is this a PHP issue?
Is there a way to change the connection settings in PHP or freetds? (I know
I can set them on the server)?
 

Thanks for any help.
pk



More information about the FreeTDS mailing list