PDO SQL Server扩展间歇性断层 [英] PDO SQL Server extension faulting intermittently

问题描述

错误101错误15插槽未连接从我的dev的服务器切换后连接重置和我得到间歇性数据库驱动程序。究其原因似乎是PDO SQLSRV驱动程序，我试图用使用SQL Server 2008 R2 SQL本机客户端连接到SQL Server 2005数据库。

I'm getting intermittent Error 101 connection reset and Error 15 Socket Not Connected from my dev server after switching database drivers. The reason seems to be the PDO Sqlsrv drivers I'm trying to use to connect to a SQL Server 2005 database using the SQL Server 2008 R2 SQL Native Client.

我的Windows事件日志显示该应用程序错误就在每个故障的时间：

My windows event log shows this in Application Errors right at the time of each failure: :

错误的应用程序路径：C：\\ WAMP \\ BIN \\ apache的\\ apache2.2.17 \\斌\\ httpd.exe结果
  错误模块路径：C：\\ WAMP \\ BIN \\ PHP \\ php5.2.11 \\分机\\ php_pdo_sqlsrv_52_ts_vc6.dll

Faulting application path: C:\wamp\bin\apache\apache2.2.17\bin\httpd.exe
Faulting module path: c:\wamp\bin\php\php5.2.11\ext\php_pdo_sqlsrv_52_ts_vc6.dll

服务器从WAMPServer 2.1为Windows Server 2008 R2运行Apache 2.2.17，在两个PHP版本5.2.11和5.3.9出现问题。老MSSQL司机5.2.11正常工作。

The server is Windows Server 2008 R2 running Apache 2.2.17 from WAMPServer 2.1, the issue occurs on both PHP version 5.2.11 and 5.3.9. The old mssql driver worked fine on 5.2.11.

我从官方SQLSRV驱动项目对codePLEX 。我使用的驱动程序的线程安全版本，我使用的是线程安全的PHP。 <一href=\"http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/thread/f43a9281-dadd-45e2-8147-c6613a5d6eac/\"相对=nofollow>我证实线程安全是不是问题 /我用PHP 5.2.11驱动程序的VC6版本我的副本与VC ++编译6，和我使用的驱动程序的版本VC9与5.3.9因为它编译VC9。

I got the latest versions of the drivers from the official Sqlsrv driver project on codeplex. I'm using the Thread Safe version of the drivers as I'm using thread safe PHP. I confirmed thread safety is not the issue/ I used the VC6 version of the drivers with PHP 5.2.11 as my copy was compiled with VC++ 6, and I used the VC9 versions of the driver with 5.3.9 as it's compiled with VC9.

这是什么问题或如何可以隔离呢？

What is the problem or how can I isolate it?

推荐答案

这显然是不正确的服务器配置的结果。重新安装从头服务器和使用PHP 5.3.9，阿帕奇2.2.21和SQLSRV驱动器2.0的的新副本的php.ini中和的httpd.conf文件的工作。我相信我从不当造成靠不住的行为旧服务器的配置复制了一些设置。

This was apparently the result of an incorrect server configuration. Reinstalling the server from scratch and using PHP 5.3.9, Apache 2.2.21 and the sqlsrv driver 2.0 worked with fresh copies of the php.ini and httpd.conf files. I believe I improperly copied some settings from the old server's configuration which caused wonky behavior.

这篇关于PDO SQL Server扩展间歇性断层的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！