Bug #35884 [NoF->ReO]: mssql connection is lost after mssql_query (with bigint)
Edit report at https://bugs.php.net/bug.php?id=35884&edit=1
ID: 35884
Updated by: aharvey@php.net
Reported by: muratyaman at gmail dot com
Summary: mssql connection is lost after mssql_query (with
bigint)
-Status: No Feedback
+Status: Re-Opened
Type: Bug
Package: MSSQL related
Operating System: Win XP Pro SP2
PHP Version: 5.1.2RC1
-Assigned To: fmk
+Assigned To:
Block user comment: N
Private report: N
New Comment:
Reopened, although I believe the normal advice nowadays is to use the sqlsrv
driver when on Windows, which you can get from http://sqlsrvphp.codeplex.com/
Previous Comments:
------------------------------------------------------------------------
[2012-01-31 10:48:02] bestdragon dot it at gmail dot com
This error still exists.
I don't know how to solve it, because sometime my query work perfectly,
sometimes it doesn't work and print the error "Warning: mssql_query()
[function.mssql-query]: Unable to set query in /dir/apache/html/filename.php on
line num" after too time...
The query is:
SELECT * FROM (SELECT row_number() OVER (ORDER BY col1) AS rownum, col1, col2,
col3, col4, col5 FROM myTable WHERE col1!='') as A WHERE rownum BETWEEN (5001)
AND (10000)
Please fix this bug earlier! I need to use this query for work.
Thank's a lot!
------------------------------------------------------------------------
[2006-01-11 01:00:02] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
------------------------------------------------------------------------
[2006-01-03 20:37:05] fmk@php.net
1) BIGINT is not a known data type for MS SQL Server 6.5. Microsoft has not updated the API (used
for the mssql extension) since this version of the server.
You can use the php_dblib.dll extension this is build using FreeTDS and is more up to date.
2) You should use msql_init(), mssql_bind() and mssql_execute() functions when working with storrd
procedures. mssql_query() can handle multiple results but it can not return output parameters or
return values.
Please make sure to use mssql_next_result() to process additional result sets.
------------------------------------------------------------------------
[2006-01-03 16:25:26] muratyaman at gmail dot com
Sorry, my comments in PHP code before running the 1st query might be misleading (forgot to modify
during submission to here). Discard them and please refer to the explanation.
Thanks.
------------------------------------------------------------------------
[2006-01-03 16:19:55] tony2001@php.net
Assigned to the maintainer.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
https://bugs.php.net/bug.php?id=35884
--
Edit this bug report at https://bugs.php.net/bug.php?id=35884&edit=1
Thread (7 messages)