> -----Original Message-----
> Sent: Friday, July 23, 2004 4:07 PM
> Subject: [PHP-DB] Getting PHP for Windows to talk to MS SQL?
> I'm trying to get PHP (for Windows) to talk to MS SQL Server. 
> This is proving to be non-trivial. 
> I downloaded and installed the Windows binary package on my 
> machine (the machine is running Microsfot Windows XP 
> Professional), and jumped through the hoops to get it running 
> under Apache 2.0. So far, so good.
> Now, the first thing I noted was that the mssql functions 
> actually don't seem to exist in the binary... and apparently 
> you have to compile them in to PHP, after having built 
> FreeTDS. This seems a bit odd, as it's not at all clear to me 
> that FreeTDS actually will build under Windows at all (it 
> being a UNIX solution). I did try building it under cygwin, 
> which ended with a flurry of error messages in bsqldb.c, so 
> this assumption seems correct. 

They are not compiled into the binary, but are available as an extension
that you enable via php.ini


> Any ideas what the right best way to do this is? I'd prefer 
> to use the mssql functions if I can... 

I'm doing the same thing on my workstation with Apache 2, PHP 5 and
MSSQL 2000.  
* ntwdblib.dll is in %systemroot%\system32\.  
* I am not using the bundled ntwdblib.dll
* PHP is installed in c:\php from binary zip, pecl extensions are in
* (php.ini) extension_dir = "c:\php\ext\"
* (php.ini) extension=php_mssql.dll is uncommented
* php_mssql.dll is in c:\php\ext, not %systemroot%\system32\
* SQL Server 2000 is installed

The md5sum of my ntwdblib.dll is 4a76e50c4921ca9a35c5bb3c010b0cf8
I tested with the bundled ntwdblib.dll, which worked as well.

Try moving php_mssql.dll back into your extension directory, ensure that
the 'extension_dir' value is correct, restart apache and test again.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to