php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #44869 MSSQL Connect => Access Violation
Submitted: 2008-04-30 12:52 UTC Modified: 2010-05-27 10:02 UTC
Votes:4
Avg. Score:4.8 ± 0.4
Reproduced:4 of 4 (100.0%)
Same Version:2 (50.0%)
Same OS:3 (75.0%)
From: vds dot jeroen at gmail dot com Assigned: pajoye (profile)
Status: Closed Package: MSSQL related
PHP Version: 5.2.6 OS: Windows XP SP2
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: vds dot jeroen at gmail dot com
New email:
PHP Version: OS:

 

 [2008-04-30 12:52 UTC] vds dot jeroen at gmail dot com
Description:
------------
When trying to connect to a local MSSQL 2005 Express server using mssql_connect() in combination with IIS 5.1 on Windows XP SP2, I get this error:

PHP has encountered an Access Violation at 7333F15A

When I run the script some more, I get this error.
PHP has encountered an Access Violation at 7333F179

When I run the script some more, I don't have a problem.

When I connect to another MSSQL server than my local one, I don't have a problem at all.

I tried it with PHP 5.2.5 and 5.2.6RC5

I'm not the only one with this problem:
http://www.php.ru/forum/viewtopic.php?p=43508&sid=f670026df23ed66bcbed99e77344bc52
http://bugs.php.net/bug.php?id=44718

When I use Apache 2.2.2, Apache crashes with PHP 5.2.5 when trying to connect.

BTW: I'm using the newer ntwdblib.dll (2000.80.194.0)


Reproduce code:
---------------
$username = "sa";
$password = "*********";
$database = "plrapport";

$conn = mssql_connect("LAPTOPHP\SQLEXPRESS","$username","$password");



Expected result:
----------------
Nothing should happen, but the connection should be made. I check if the connection is made by running a query.

Actual result:
--------------
When I just try to connect, with or without issueing a query, I get 
PHP has encountered an Access Violation at 7333F15A

I tried to make a backtrace, but I ended up with a very long mht file.
Download it here:
http://maybeme.be/Downloads/CrashHang_Report__PID_3208(2_dumps)__PID_668(2_dumps)__04302008142359968.mht

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2008-05-07 17:16 UTC] vds dot jeroen at gmail dot com
I still have the same problem with 5.2.6 final
 [2008-05-21 11:17 UTC] vds dot jeroen at gmail dot com
It's working when I use FreeTDS.
 [2008-08-19 07:35 UTC] svfly2 at yandex dot ru
Have same problem on WinXP apache 2.2.9 php 5.2.5

works with ntwdblib 2000.2.8.0
crash with ntwdblib 2000.80.194.0

works with win2003 server with  ntwdblib 2000.80.194.0
 [2008-11-11 14:42 UTC] kalle@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php for Win32

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.


 [2010-05-27 07:43 UTC] fenik17 at gmail dot com
Patched ntwdblib.dll v.2000.80.194.0: http://rouse.drkb.ru/other/ntwdblib_patched.zip
 [2010-05-27 10:02 UTC] pajoye@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: pajoye
 [2010-05-27 10:02 UTC] pajoye@php.net
The lib has already been updated, using an official version.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Wed Jan 15 06:01:30 2025 UTC