First FreeTDS should have built support for TDS protocol version 8.0. The tds protocol version should also be set to 8.0 in interface file. Details about this is included with the FreeTDS source distribution. -- bob On Mon, 18 Aug 2003, vish.kohli wrote: > Thanks for your response. > My script is running on Linux. I am trying to retrieve simple data such as > text and numbers. > I am not sure what the TDS protocol setting should be. What are the typical > settings and how can I check it? > > Would appreciate any tips for debugging. > > Thanks. > > ----- Original Message ----- > From: "Robert Twitty" <rtwitty@neutron.ushmm.org> > To: "vish.kohli" <vish.kohli@attbi.com> > Cc: <php-db@lists.php.net> > Sent: Monday, August 18, 2003 8:28 AM > Subject: Re: Query runs fine on Console but not in PHP > > > > What platform are you using? Since it appears that the script is > > crashing, you are probably on Linux or some other UNIX flavor. If this is > > the case, the TDS protocol setting may not be correct. What type of date > > are you retrieving with this stored procedure? > > > > -- bob > > > > On Sun, 17 Aug 2003, vish.kohli wrote: > > > > > Hi, > > > > > > I am trying to execute a stored procedure in PHP via mssql_query () > > > function. I pass 8 parameters to it. > > > The query runs fine in SQL Query Analyzer but when I run it thru PHP, it > > > behaves strangely. I can get number of rows (mssql_num_rows()) and > number of > > > fields (mssql_num_fields()) in PHP, but when I try to execute > > > mssql_fetch_object() or mssql_fetch_array() on the same result > identifier, I > > > get a "Page could not be displayed" (standard internet error page). > > > > > > Please help. > > > Thanks in advance. > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
