PHP + MS SQL Server - how to make it work??? HELP!!! :(

phinix · 27 Oct 2009 at 15:52

OK. I hope this is right place to ask.
Guys, I'm totaly noob in this stuff, so please be patient

I have a Windows 2003 server with MS SQL 2003 server on it.
I also have a php webpage and want to make it work with database on SQL server.
HOW CAN I DO IT?

Please take me through all the stages slowly cause I may lost somewhere and don't know what did wrong.

First of all, need to install PHP on my pc and on server, is that correct?
IIS server is configured correctly, cause it has some website already there which is running (ASP, not php) so I believe I need to work on sth else now?

There's php file, there is also html page with from that runs that php file. However nothing happens after I clik submit button. It asks if I want to open input.php file, when I click OK, nothing happens.. what is wrong here?

Deleted User 234324 · 27 Oct 2009 at 20:36

check your server configuration so that it knows what to do with php files.

Pho · 27 Oct 2009 at 21:03

Try following this: http://www.php.net/manual/en/install.windows.iis6.php - when you install PHP make sure you enable the MSSQL (might be called Microsoft SQL) extension.

I'd also grab SQL Server 2008 Express (free) - http://www.microsoft.com/express/sql/default.aspx unless you have to use the older version of SQL Server (or you're using some paid license).

phinix · 28 Oct 2009 at 21:08

guys, after another day working on this to make it work I have some new conclusions.

Hello world and other stuff works fine. I checked with other, default php website from pub folder and it works.
Thing is for some reason server doesn't know what to do with mssql command. When I use mssql_connect () in my php file it doesn't do anything. Getting standard http 500 error, that page cannot be displayed.
When I change it only to odbc_connect(), it gives my my error message from my php file and odbc_error() info which is IM002.
I believe this is connection error, or incorrect driver..
Things is - this is Windows server 2003 with MS sql server 2003 installed. IIS seems to be configured correctly. I also installed PHP on C drive of the server and changed ini file to use mssql, updated system PATH etc...
Now, when I add new website in IIS manager and put those html and php file in it, it doesn't work.
What is missing here? Tell me if you need more info about the whole system or any other details to help find a problem...