ID: 13008 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: Linux 2.2.12-20 Red Hat 6.1 PHP Version: 4.0.6 New Comment:
OK, I know that a lot of things changed in this test, sorry about that - too much time elapsed I guess... I have the following configuration: Mandrake 8.2 system Apache 2.0.43 FreeTDS 0.60 PHP 4.3.0-dev (latest snap) PHP API 20020307 PHP Extension 20020429 Zend Extension 20021010 './configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-gd' '--with-zlib' '--with-jpeg' '--with-png' '--with-mssql' '--with-sybase=/usr/local' '--enable-track-vars' '--with-mysql' With that setup all apears to work OK now. I can have a failing insert due to a key restraint in the database table and still do updates and other inserts without having to close the connection. Thanks for the help and your patience with my getting around to testing it. Previous Comments: ------------------------------------------------------------------------ [2002-10-30 08:08:45] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-10-30 08:04:46] [EMAIL PROTECTED] I'm trying to recreate the problem, but unfortunately I no longer have the system that I originally had the problem on. I only have available an HP-UX 11.0 system and a Mandrake 8.2 system, and I'm having all kinds of problems building PHP on the HP-UX system. I have just about got it built except for some GD shared library problems. Based upon Chris's last report the problem still exists. Hopefully I will be able to test again by the end of the week. ------------------------------------------------------------------------ [2002-10-30 03:59:13] [EMAIL PROTECTED] Im am using Windows NT and PHP 4.2.3 and experience the same problems with MS SQL Server 2000: i try to do multiple inserts in one query: <script> $sql = " INSERT INTO tbl (col1, col2) VALUES( $int1, '$str1'); INSERT INTO tbl (col1, col2) VALUES( $int2, '$str2'); ..." mssql_query($sql); </script> the thing is: one query with more than one insert works, the data is is in the DB. But all others fail. It also works if I do only one insert at the time. Even it works, if I put all inserts in one string and do 10000 inserts with one query. I see a problem here, because the amount of data can grow very large. so there are probably some restrictions to the contents of a string-Variable and the String-Length of a query. I dont understand, why it is not possible to do a second query after inserting more then one lines... chris ------------------------------------------------------------------------ [2002-10-25 01:00:06] [EMAIL PROTECTED] No feedback was provided for this bug for over 2 weeks, 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". ------------------------------------------------------------------------ [2002-10-09 11:59:14] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip If the problem still occures try upgrading to freetds-0.53 and seeing if that'll solve the problem. ------------------------------------------------------------------------ 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 http://bugs.php.net/13008 -- Edit this bug report at http://bugs.php.net/?id=13008&edit=1