#18271 [Opn]: Problems reading MSSQL data of type "real"

ID: 18271 User updated by: Brendan@callaghans.com.au Reported By: Brendan@callaghans.com.au Status: Open Bug Type: MSSQL related Operating System: Win2000 PHP Version: 4.3.0 New Comment: I just looked up the manual page for MSSQL, and it mentions using the ntwdblib.dll file (which exists in the PHP archive under dlls/). I've never concerned myself with that file because when I originally installed PHP, the MSSQL connection worked as soon as I copied across php_mssql.dll. Do I need to replace ntwdblib.dll as well to test your fix? Previous Comments: ------------------------------------------------------------------------ [2003-01-21 19:48:19] Brendan@callaghans.com.au I've tried replacing the extension file, but there was no change. You said "related dlls from the dlls/ folder", AFAIK nothing in the dlls/ folder is related to mssql. So all I did was copy extensions/php_mssql.dll into c:\php, restarted my browser session and observed that I'm still getting the same data from real columns. If I need to restart IIS to test this properly, tell me. ------------------------------------------------------------------------ [2003-01-20 00:32:18] sniper@php.net Yes, replace the php_mssql.dll and related dlls from the dlls/ folder. ------------------------------------------------------------------------ [2003-01-19 21:07:24] Brendan@callaghans.com.au Nope, unfortunately I haven't been able to do anything yet, because my local sysadmin has been difficult to contact, and I need his approval to log on to the server. In the meantime, I've worked around the problem by changing all my real type columns to decimal. When I get a chance, I'll test your snapshot and post my results here. My previous question still stands. I downloaded the archive you pointed me to, but all you said was "try it". I'm assuming that you mean to try the php_mssql.dll file. Am I correct? ------------------------------------------------------------------------ [2003-01-17 21:16:19] sniper@php.net Did you try it or not? ------------------------------------------------------------------------ [2003-01-15 19:19:12] Brendan@callaghans.com.au And it's just a case of overwriting my current php_mssql.dll with the one in this archive? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/18271 -- Edit this bug report at http://bugs.php.net/?id=18271&edit=1