freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: Stallon Selvan <stallonselvan AT gmail.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)
Date: Tue, 13 Jul 2010 22:23:59 +0530

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), 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 /home/wwwuser/public_html/db.mssql.php
on line 558.
user warning: Error: - Changed database context to 'Staging_DB'.

Regards,
Stallon Selvan

[freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Stallon Selvan, 07/13/2010
- Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Robert Gonzalez, 07/19/2010
- Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Frediano Ziglio, 07/19/2010
  - Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Stallon Selvan, 07/20/2010
    - Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Frediano Ziglio, 07/22/2010
      - Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Stallon Selvan, 07/22/2010
        
        Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Frediano Ziglio, 07/22/2010
        
        Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Robert Gonzalez, 07/22/2010
        
        Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Stallon Selvan, 07/22/2010
        Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Tacho, 07/22/2010
        Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well), Stallon Selvan, 07/22/2010