boolean
Posts: 62
|
Posted: 10/06/2011, 12:05 PM |
|
Hello,
I have been using CCS4, PHP5.2, and MySQL. Now I am changing to database to MS SQL 2008 in IIS7 on Windows 7. For setting up, I do the following:
1) install the lastest PHP5.3.8 from the site http://php.iis.net/ into folder C:\Program Files (x86)\
2) download ntwdblib.dll and php_mssql.dll and put them in /ext/ folder as well as having
extension=ntwdblib.dll
extension=php_mssql.dll
in the php.ini file
3) restart the computer
When I run the phpinfo();, I don't see mssql anywhere.
I create a test page having mssql_connect();, I get the error message
Fatal error: Call to undefined function mssql_connect()
4) I try to copy the PHP folder from C:\Program Files (x86) into C:\Windows\, but I get the same result.
I send the question to CCS tech support, but they ask me to check with PHP support forums. So, I hope someone could help me solve this.
Thanks a bunch.
|
|
|
Joachim Uersfeld
|
Posted: 10/06/2011, 1:03 PM |
|
Look at one of the lot of entries in Google http://www.easysoft.com/developer/languages/php/sql_ser...x_tutorial.html
or
http://msdn.microsoft.com/en-us/library/cc793139(v=sql.90).aspx
or
http://www.google.de/search?q=mssql+server+2008+php+connect
> 1) install the lastest PHP5.3.8 from the site http://php.iis.net/
> into folder C:\Program Files (x86)\
Is this a offical information source?
> When I run the phpinfo();, I don't see mssql anywhere.
Have you installed the SQL SERVER 20008?
Joachim
|
|
|
PCHome
Posts: 57
|
Posted: 10/06/2011, 1:08 PM |
|
I just went through this recently at work and had to download a driver set from Microsoft. Unfortunately I did not document what worked but, as Joachim point out, researching through Google got it up and running. There is also a PHP configuration editor that works through the Server control panel that is really helpful in easily seeing which features are loaded and which are not although I'm not sure if it's available for non-server versions of Windows.
|
|
|
boolean
Posts: 62
|
Posted: 10/07/2011, 6:23 AM |
|
Hi Joachim and PCHome,
Thanks for the quick reply.
I did install MSSQL Server 2008 and also MSSQL Server 2008 R2. I check out the link Joachim mentions and research more about sqlsrv, which is total new to me. I failed to get it right.
I try another way by:
1) erase everything I did with PHP and restart
2) go to the site php.net and download php-5.3.8-nts-Win32-VC9-x86.msi
3) install PHP into C:\Windows
4) add ntwdblib.dll and php_mssql.dll in /ext/ folder and add extension=ntwdblib.dll, extension=php_mssql.dll in php.ini
It still doesn't work. What I don't understand is that mssql does not show anywhere in phpinfo().
Help please. THANKS.
|
|
|
|