Getting PHP to find my SQL server...

[bobsmith1492]

I'm trying to set up a basic PHPBB forum on my website.

I have Apache 2.2.6 running and serving up my site. I then added PHP and installed Microsoft SQL Server 2005. Both seem to be working; I created a database for the server and can connect to it using ProxyInspector.

I can also go to the PHPBB install page. Everything shows up as it should, all fancy-like, but when I go to connect to the SQL server it sits there, "Waiting for server..." then returns "Failed - no error message."

Any ideas for me?

Everything is being served from the same computer which is running Vista Business 64-bit. I ran through all the settings here and it looks good (using a funky port though I told PHPBB to use the same port and unblocked it via Windows Firewall).

One other symptom: when I restart, my Apache server fails to start and will not do so until I remove the PHP module and restart. Once I restart, it works fine and PHP works if I restart Apache with the module loaded.

 

[drebo]

I wasn't aware PHPBB had a connector for MSSQL Server. Typically it's used with MySQL.

 

[ScottMac]

It's been a while since I checked, but PHP (last time I tried) doesn't like MSSQL without jumping through some ugly hoops.

MySQL would be the first choice, or postgre

 

[bobsmith1492]

Really... huh. There is an extension in the .ini file (extension=php_mssql.dll) that is supposed to work for MS SQL though it says SQL 2000, not 2005 when selecting it when trying to connect.

I guess I'll try MySQL, then. May as well stick with open-source. 😛

 

[drebo]

PHP itself can interface with MSSQL, yes. However, I do not believe that PHPBB is written to work with MSSQL Server (there are different functions needed).

 

[bobsmith1492]

I switched over to MySQL and everything is running smoothly. Thanks!