The answer is a bug in the Drupal Sql Server driver that sits on top of Drupal's PDO implementation and Microsoft's Sql Server driver. Sending an empty command to sql server, which happens when the transaction savepoint functionality is called by Drupal, causes
the fault. Details are here: http://social.technet.microsoft.com/Forums/en-US/sqldriverforphp/thread/2429f26b-287e-474e-8472-2c40f2a6ba10 thanks everybody for the ideas and help.
Marked as answer by mbanavige on Feb 18, 2012 02:07 PM
Thank you so much panmanphil! This did the trick and solved my problems. I never did get a chance to rebuild our whole enviroment from scratch, but thankfully, I won't need to. Thanks again!
In case anyone needs it, here is a direct link to the special patch made for the Drupal SQL driver:
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Oct 05, 2011 02:43 AM|LINK
Hi,
For the Microsoft Foundation Library errors "MSVCR90.dll, version: 9.0.30729.6161"
visit the Microsoft Download Center and Download the installer(s) for the Visual Studio 2008 runtimes.
Save the files to hard disk add or modify the file name from the download center
VS2008-SPX-vcredist-NN.exe NN being one for X86 and X64 SPX if this is a service pack. You should have at least two packages.
Do not run the Visual Studio 2008 runtime installers online id it asks to repair or remove take the remove option first.
After the Visual Studio 20008 runtime installer has finished run the installer again.
Look at Search (Google or Bing) on the "Faulting module name: MSVCR90.dll, version: 9.0.30729.6161" results.
http://www.google.com/search?q=Faulting+module+name%3A+MSVCR90.dll%2C+version%3A+9.0.30729.6161&rls=com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1&rlz=1I7GUEA_en .
It would appear that one or more Software Installers can corrupt the MFC C++ libraries.
For the PHP SQL Driver coding use Brian Swans examples and the MSDN Documentation.
A very old is the standard "Hello world" http://en.wikipedia.org/wiki/Hello_world_program this may seem dumb
seasoned programmers use this method.
For PHP SQL Driver this is "Hello Sql Server" then use the working examples to check your code.
Martin
Community Member Award 2011
panmanphil
3 Posts
Re: PHP 5.3.8 Problems
Oct 07, 2011 01:44 AM|LINK
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Oct 07, 2011 02:06 AM|LINK
Hi @ panmanphil,
Thanks for the update & information :D.
So you and the SQL Server PHP Driver Forums deserve a big cheers :)
So the overlay code by Drupal and PDO is "beating" up the Microsoft driver.
I still would keep a watch on the Visual Studio 2008 runtime installs.
There are alot of conflicts with third party vendors and the runtimes.
Martin
Community Member Award 2011
Kalio
12 Posts
Re: PHP 5.3.8 Problems
Oct 13, 2011 08:22 PM|LINK
Thank you so much panmanphil! This did the trick and solved my problems. I never did get a chance to rebuild our whole enviroment from scratch, but thankfully, I won't need to. Thanks again!
In case anyone needs it, here is a direct link to the special patch made for the Drupal SQL driver:
http://drupal.org/node/1300312
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Oct 15, 2011 12:45 AM|LINK
Hello @ xxrsdsdk209,
The other users in this thread so far have found a solution.:D.
Could you post the PHP code or post the IIS server log errors for failures or success ?
The alternate for IIS 7.0 IIS 7.5 Server is Enable and Turn on "Failed Request Tracing"
You can ( Google or Bing ) for the guides for FRT which should lead the the IIS Net Library.
Could you re-check the "Application Pools" and Permissions for Accounts and users.
Read the IIS Net Library guides:
http://learn.iis.net/page.aspx/624/application-pool-identities/
http://learn.iis.net/page.aspx/140/understanding-built-in-user-and-group-accounts-in-iis-7-and-above/ .
Martin
Community Member Award 2011
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Nov 22, 2011 03:16 PM|LINK
Hi,
The PHP 5.3.8 thread http://forums.iis.net/p/1182091/1997952.aspx#1997952 special case SQL Driver for PHP.
Update this thread issues related to PHP 5.3.8
regards,
Martin
Community Member Award 2011
HCamper
8048 Posts
Re: PHP 5.3.8 Problems
Jan 30, 2012 11:13 AM|LINK
Hi Kalio
PHP 5.3.8 Problems and issues get the latest version and release.
http://learn.iis.net/page.aspx/773/how-to-install-the-microsoft-web-platform-for-php/ How-To Install.
PHP Manager http://learn.iis.net/page.aspx/944/using-php-manager-for-iis-to-setup-and-configure-php/
http://forums.iis.net/t/1186508.aspx IIS 7 - Forum-FastCGI-PHP -Information.
TIA,
Martin Rasch
Community Member Award 2011