freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)
- From: Robert Gonzalez <robert AT robert-gonzalez.com>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: Re: [freetds] SQL Server 2005 Stored Procedures in PHP with TDS Version 8.0 don't work (7.0 works well)
- Date: Mon, 19 Jul 2010 11:57:44 -0700
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
<stallonselvan AT gmail.com>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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
--
Robert Gonzalez
http://www.robert-gonzalez.com
http://twitter.com/RobertGonzalez
http://www.linkedin.com/in/robertanthonygonzalez
-
[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
- 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),
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),
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),
Stallon Selvan, 07/20/2010
Archive powered by MHonArc 2.6.24.