ID: 9438 Updated by: fmk Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Closed Bug Type: MSSQL related Operating system: PHP Version: 4.0.4pl1 Assigned To: Comments: Handling of binary data is changed for php4.0.6. Please update and try again. Previous Comments: --------------------------------------------------------------------------- [2001-02-24 20:27:09] [EMAIL PROTECTED] When I try to retrieve image field from MSSQL7 database I get "PHP has encountered an Access Violation at 77FCA9EA" and all PHP engine becomes unstable after this. The script is very simple: <? include("msdb.php"); $id=$HTTP_GET_VARS["id"]; $rs=mssql_query("select Image from SpecBannerData where SpecBannerID=" . $id,$conn); $arr=mssql_fetch_row($rs); if ($arr) { header( "Content-type: image/jpg"); echo $arr[0]; } ?> msdb.php: <? $conn=mssql_connect("127.0.0.1","sa",""); if (!$conn) { echo ("Can not connect to the database"); } if (!mssql_select_db("metasearch",$conn)) { echo ("Can not connect to the database"); } ?> I'm quite new in PHP, but I met some other people report the same problems in PHP-related forums. I used only precompiled PHP modules downloaded from php.net. Best regards, Leonid Freidin --------------------------------------------------------------------------- ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=9438&edit=2 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]