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

Not sure what the tell you about the tds version, but as it relates to the
message you are getting on failure, have your tried ramping up your
mssql.min_error_severity and mssql.min_message_severity to 16 instead of the
default value of 10? Most context change messages are just notifications
from the server (all statuses from 1-15 are just notifications) but, in my
experiences, since they return as a response from the server, if you not
cycling through multiple results they come back as the first and only result
from the database.

Changing my severity levels to 16 for both Sybase and MS SQL have prevented
these context change messages for me.

On Tue, Jul 13, 2010 at 9:53 AM, Stallon Selvan <[email protected]>wrote:

> 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 mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



-- 
Robert Gonzalez
http://www.robert-gonzalez.com
http://twitter.com/RobertGonzalez
http://www.linkedin.com/in/robertanthonygonzalez