07 diciembre 2009

Conectar php a MSSQL Server

For the mssql extension to work, all of the following must be true -

The php.ini that you are changing must be the one that php is using.

The php_mssql.dll must be in the ext folder.

The extension_dir setting in php.ini must be set to the ext folder, something like extension_dir = c:\php\ext

To get changes made to php.ini to take effect, you must stop and start the IIS web service. Do this in the services control panel or reboot your computer. Just stopping and starting the web site in the IIS management console is not enough.

mssql requires: ntwdblib.dll to be available on the Windows PATH. It is better to add the php folder to the Windows PATH instead of moving any files around. Re-logon or reboot your computer to get any changes made to the Windows PATH statement to take effect.

ntwdblib.dll that comes with php5 does not work

The php folder must have proper permissions set to allow the IIS user account to read the files in the php folder and in the ext folder.

Steps to repair your DLL Error after you download ntwdblib.dll:

1. Extract this file with WinZip or with WinRar.
2. Copy it to "windows \ system32 \" directory.
3. Click on "Start" button then click on "Run" button.
4. Enter "regsvr32 xxx.dll" to register it.

1 comentarios:

daspeac dijo...

I have heard about another way of mssql database recovery. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.