[Bug 374925] [NEW] PHP5-MSSQL package needed

[Seth.Griffin]

Public bug reported:

Binary package hint: php5-sybase

Description:	Ubuntu 9.04
Release:	9.04

libapache2-mod-php5:
  Installed: 5.2.6.dfsg.1-3ubuntu4.1
  Candidate: 5.2.6.dfsg.1-3ubuntu4.1
  Version table:
 *** 5.2.6.dfsg.1-3ubuntu4.1 0
        500 http://us.archive.ubuntu.com jaunty-updates/main Packages
        500 http://security.ubuntu.com jaunty-security/main Packages
        100 /var/lib/dpkg/status
     5.2.6.dfsg.1-3ubuntu4 0
        500 http://us.archive.ubuntu.com jaunty/main Packages

freetds-dev:
  Installed: 0.82-4
  Candidate: 0.82-4
  Version table:
 *** 0.82-4 0
        500 http://us.archive.ubuntu.com jaunty/main Packages
        100 /var/lib/dpkg/status


Problem: There is no package for Microsoft SQL Server support in PHP on Ubuntu.
Failed solutions: using php5-sybase package. 

When using php5-sybase querying ntext data (unicode text) Microsoft SQL
Server 2000 gives the following error:

"Unicode data in a Unicode-only collation or ntext data cannot be sent
to clients using DB-Library (such as ISQL) or ODBC version 3.7 or
earlier."

Successful solutions:

Reconfigure and re-build .deb packages for libapache2-mod-php5 and
freetds-dev.

Reconfigure libapache2-mod-php5:

http://panthar.org/2006/06/15/php-with-mssql-on-ubuntu-606/

Reconfigure freetds-dev:

Changed this line in debian/rules

--with-tdsver=4.2
to
--with-tdsver=8.0

Why this works:

1. The mssql module in php was built to query sql server, not sybase.
2. SQL Server 2000 requires at least version 7 but works best with version 8. I have not tested this on SQL server 2005 or above.

Proposed solution:

Package php5-mssql for out of the box pdo-dblib support and mssql_*
function support.

If sybase works with tdsver 8.0, then it is my recommendation that
freetds-dev be modified to build to that version rather than 4.2.

If sybase does not work with 8.0, then it is my recommendation that an
additional freetds8.0-dev package be provided  to work with php5-mssql.

If you need more information, package diffs, or anything else, please
ask, I'll be happy to provide them.

Regards,
Seth

** Affects: php5 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
PHP5-MSSQL package needed
https://bugs.launchpad.net/bugs/374925
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to php5 in ubuntu.