SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)

I'm running a PHP web app running on Ubuntu 8.04 which is interfacing with SQL Server 2005. I use FreeTDS to connect to MSSQL2005 with the following lines in my freetds.conf

[MYDB]
    host = 192.168.1.11
    port = 1433
    tds version = 7.0
    client charset = UTF-8

This works perfectly however if I switch to tds version = 8.0 (which I want to), my php script throws exceptions like:

The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 2 ("@bPublic"): Data type 0x32 is unknown.

Additionally sometimes, giving me the following errors in some stored procedures

stored procedure execution failed in db.mssql.php on line 558. user warning: Error: - Changed database context to 'Staging_DB'.

Output of ./tsql -C

Compile-time settings (established with the "configure" script)
                        Version: freetds v0.82
         freetds.conf directory: /usr/local/etc
 MS db-lib source compatibility: no
    Sybase binary compatibility: no
                  Thread safety: yes
                  iconv library: yes
                    TDS version: 5.0
                          iODBC: no
                       unixodbc: no

ansaurus

tags:

views:

answers:

SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)

related questions