PHP/IIS/MSSQL install questions

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Post Reply
phart
Posts: 5
Joined: Thu May 28, 2009 3:04 pm

PHP/IIS/MSSQL install questions

Post by phart » Thu May 28, 2009 3:12 pm

Hello,

When I go to the installer page, MS SQL is not in the list. Our IIS install uses it for many other apps and most of our PHP scripts are using MS SQL via an ODBC. Is there some setting somewhere I need to enable for PMF to see our SQL Server?

Thanks,
Pat

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: PHP/IIS/MSSQL install questions

Post by Thorsten » Thu May 28, 2009 8:02 pm

Hi,

you need to enable the ext/mssql extension for phpMyFAQ. Currently we don't support ODBC.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

phart
Posts: 5
Joined: Thu May 28, 2009 3:04 pm

Re: PHP/IIS/MSSQL install questions

Post by phart » Thu May 28, 2009 8:11 pm

Hello,

Ive been doing some reading and found that the ext sqlsrv replaces the now depreciated mssql ext. We have the sqlsrv ext working fine. Is there some mod that can be made to replace checks for mssql with sqlsrv?

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: PHP/IIS/MSSQL install questions

Post by Thorsten » Thu May 28, 2009 8:33 pm

Hi,

we cannot use the new sqlsrv extension right now but as soon as possible. We're in contact with Microsoft because of some missing features in ext/sqlsrv. So please use ext/mssql until ext/sqlsrv is ready. :-)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

phart
Posts: 5
Joined: Thu May 28, 2009 3:04 pm

Re: PHP/IIS/MSSQL install questions

Post by phart » Thu May 28, 2009 8:56 pm

Well,

Its not that we arent willing to try but I (could be wrong but) dont think mssql and sqlsrv can be active at same time. Or at least thats what we have come to understand after attempting to use the mssql ext.

Our php dir has the mssql dll inplace but the checks always report it is not enabled, using phps' extension_loaded('mssql') call.

Any ideas there?

Thanks for the clearification on the sqlsrv ext BTW.

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: PHP/IIS/MSSQL install questions

Post by Thorsten » Fri May 29, 2009 7:32 am

Hi,
phart wrote:Our php dir has the mssql dll inplace but the checks always report it is not enabled, using phps' extension_loaded('mssql') call.
did you enabled ext/mssql in your php.ini file?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

phart
Posts: 5
Joined: Thu May 28, 2009 3:04 pm

Re: PHP/IIS/MSSQL install questions

Post by phart » Fri May 29, 2009 1:34 pm

Most certainly. We spent a large part of the day yesterday working on the php dll files and configurations.

The issue seems to be that the SQL server is on its own and the IIS box does not have other SQL tools running on it, but we have however moved the ntwdblib.dll into various locations.

UPDATE:
I think I am just going to break a few rules and put MySQL out there for this to get it done. Would be easier anyways I think :)

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: PHP/IIS/MSSQL install questions

Post by Thorsten » Fri May 29, 2009 2:32 pm

Hi,

is it working now? :-)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

phart
Posts: 5
Joined: Thu May 28, 2009 3:04 pm

Re: PHP/IIS/MSSQL install questions

Post by phart » Fri May 29, 2009 2:34 pm

I will update here once it is, but I have no doubts that once I put MySQL on the box things will be fine.

Post Reply