Page 1 of 1

PHP/IIS/MSSQL install questions

Posted: Thu May 28, 2009 3:12 pm
by phart
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

Re: PHP/IIS/MSSQL install questions

Posted: Thu May 28, 2009 8:02 pm
by Thorsten
Hi,

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

bye
Thorsten

Re: PHP/IIS/MSSQL install questions

Posted: Thu May 28, 2009 8:11 pm
by phart
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?

Re: PHP/IIS/MSSQL install questions

Posted: Thu May 28, 2009 8:33 pm
by Thorsten
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

Re: PHP/IIS/MSSQL install questions

Posted: Thu May 28, 2009 8:56 pm
by phart
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.

Re: PHP/IIS/MSSQL install questions

Posted: Fri May 29, 2009 7:32 am
by Thorsten
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

Re: PHP/IIS/MSSQL install questions

Posted: Fri May 29, 2009 1:34 pm
by phart
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 :)

Re: PHP/IIS/MSSQL install questions

Posted: Fri May 29, 2009 2:32 pm
by Thorsten
Hi,

is it working now? :-)

bye
Thorsten

Re: PHP/IIS/MSSQL install questions

Posted: Fri May 29, 2009 2:34 pm
by phart
I will update here once it is, but I have no doubts that once I put MySQL on the box things will be fine.