Problems with PHP forums and MSSQL?

Hello I have wanted to set up a group of php forums much like some freinds of mine.

I have been offered a host for free by a family freind and he only has mssql.

We were told that php forums were compatible with mssql as most forum types tend to use mysql nowadays.

The problem he is having is that forums lock up on him and he has been unable to find the cause.

I know this is a pretty vague description of our problem and when I know more I shall post it up but has anyone ever heard of problems like this before in case its a general thing.

Thanks in advance.

Well, I can tell you that PHP and mssql work very well together. I have used them for several projects.

Can you tell us what PHP forums he is using? Does it have built in mssql support? Trying to use forums that are built for use with mysql will not work for mssql. In fact, I don't know if I have even seen any forums with mssql support....I'd have to look around..

He downloaded them from

www.phpbb.com

Theyre home page says that they are ms-sql supported, I'll be off home sometime soon and if I get in touch with him Ill make sure he comes here and posts the problem in greater detail then I. Obviously its just a problem we are having then

Thanks.

Ok I am going to quote his problem,

Couple of things..make sure that her copies the php_mssql.dll to his windows/system or winnt/system32 directory. Also, make sure he has installed the client portion of mssql on the server that is running php....

Hi all

Just read your problem with the php_mssql.dll. I still have the same problem and still no solution

I copied the dll in the servers "system32" folder and I've also installed the client-tools of MS-SQL 2000-Server.

In the php.ini I changed the extensions-entry from . to c:winntsystem32 ...

Any suggestions?

Greetings
Martin Bucher, Zurich
mbucher@login.ch

I'm having the same issue. I'm using MS SQL 7.0. I was under the impression that you had to use the php_mssql70.dll and not the php_mssql.dll. Am I wrong? Also, from what I read, the dll should be loaded in the %ROOT%/System and /System32 AND yourdrive:/php ??? Someone mentioned having the MS SQL client services installed? Does this apply if the database is installed on the web server (small application)? Also, are you guys using the ISAPI install or the cgi based .exe install (IIS server). I'm using the .exe method (NON ISAPI) perhaps this is causing a problem for me?

What part of your php.ini's are you altering? The extension_dir path under PATHS AND DIRECTORIES? Or are you changing the extension=php_xxx under the Dynamic Extension section?

I'm so screwd up here...someone help.