Connecting to MSSQL with Apache and PHP on Windows

I set up a Windows server as a WAMP server (Windows, Apache, MySQL, and PHP) to run vBulletin. Everything worked fine, and the learning curve was pretty short.

Then I tried getting PHP to connect to a remote Microsoft SQL server. Sorry, no luck!

The apparent fix required an updated ntwdblib.dll. The one that came with the latest PHP5 bits (5.2.6) was apparently out of date (version 2000.2.8.0). A newer one, which I founded linked to from a UserScape support page, is version 2000.80.194.0. Shut down Apache, download the newer DLL (replacing the old DLL), and restart Apache. Viola! Hello, MSSQL server.

Popularity: 10% [?]

Related posts:

  1. Forgot your Windows product key? It is recoverable…
  2. Configuring Trusted SQL Connections in ASP.Net and Windows 2003
  3. Installing and configuring memcached and PHP on Windows
  4. Selective searching in Windows XP: When search all doesn’t search all
  5. Windows Server/SQL Server Performance Monitor Template

2 comments to Connecting to MSSQL with Apache and PHP on Windows

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>