Wednesday, November 19, 2008

IIS7 & PHP5

I am constantly setting up Sugar CRM versions - new ones each month - and working with different platforms as we upgrade.

The latest was to also swap to a new server platform in Windows Server 2008 with connection to a separate MS-SQL server all in 64-bit. Installed PHP5 and found amongst other things that sugar was giving a "cannot connect to database server" error when first loading.

Quoting from http://www.userscape.com/helpdesk/index.php?pg=kb.page&id=13

The resolution is with the "ntwdblib.dll Version - On some systems the ntwdblib.dll version is too old to work correctly with PHP. If your version does not end in 80.194.0 it's probably too old. You can download the 80.194 version here."

I was puzzled that the PHP5 install still includes a very old version 7.x something but went ahead and updated the ntwdblib.dll to the 80.194 version and the database error was cured.

No comments: