Problem in creating tables in DB using MSSQL server 2005

[vidhyavenkatachalam]

Hi,

I want to have my database tables in MSSQL instead of MYSQL. The steps I followed for it are :-
1. In php.ini file I enabled the extension for php_mssql.dll
2. Placed the php_mssql.dll in System32
3. When I tried to execute phpinfo(); I am getting details of msql
4. I executed the testlink 1.7.4 and clicked on new Installation

and finally I am getting the error message as mentioned below:-

Checking PHP DB extensions Warning!: Your PHP installation don't have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!

Can anyone suggest me a solution for it.

Regards,
Vidhya V

[nqdinthehouse]

Vidhya,
I am having the same issue? Were you able to solve this?

[havlatm]

Doesn't help this link? http://www.akamarketing.com/blog/99-php ... erver.html
There is described some dll dependency ...

[nqdinthehouse]

Thanks for your help. I was able to resolve this issue the other day. I had to do two things, first to uncomment the mssql extensions from the php.ini file which I had to put in Windows/System32. I also had to update the ntwdblib.dll file...and restarting IIS anytime a change was made in the ini file.

[rajprasa]

Hi,

I am trying to install Testlink 1.7.4

I have installed SQL Server 2008+ IIS6.0+PHP 5.2.8
I am working on Windows Server 2003 R2

I have uncommented the mssql extension in php.ini
Placed the ntwdblib.dll in C:\PHP & C:\WINDOWS\system32 directory

I am still getting the error:

Checking PHP DB extensions Warning!: Your PHP installation don’t have the mssql extension mssql- without it is IMPOSSIBLE to use Testlink.Failed!

I am using SQL server authentication (not windows authentication)

Should I consider installing Native client? or re-install the SQL server 2008 again?

I am new to IIS & SQL server.

I checked phpinfo.php, I can see all the extensions except mssql.

Please helpppp !!!!!

Thanks,
Raj

[ruello]

I installled it on SQL 2005 and it works fine. To do so, i installed the SQL2005 native client on the pc were runs xamp server (apache).
Hope this helps. Regards,

[rajprasa]

Hi Ruello

Thanks a lot for your post. I still dont see luck with SQL 2008. am gonna have my last resort .. if nothin works i may have to see my hopes on 2005.

I still do not see any reason why PHP extensions ain't working for MSSQL. what does PHP actually look for MSSQL?

Does it check only in php.ini? (if the extension is enabled or not)

-- or --

Does it phyiscally check if the SQL server is installed? If yes, what files does it look for?

This info would really help me to kick off again.

Thanks a lot for your time

Cheers,
Rj

[ruello]

Did you tried to install xamp lite to test if the php part works fine?

For the installation, we use a MS SQL Server 2005 Instance (not the default one) with the testlink database user DBAuser_testlink created and granted.

It is also necessary to obtain the ntwdblib.dll with the 2000.80.194.0 mini (for SQL2005) version to access a 2005 SQL Server via PHP. One way to get a free copy of ntwdblib.dll is to download MS SQL Server 2000 SP4 from Microsoft Website. It contains a copy of ntwdblib.dll version 2000.80.194.0 in the system directory. You can also get it in the MS SQL 2005 Tools distribution. This DLL will replace the one available in the XAMPP package which is designed for MS SQL Server 2000. Copy the ntwdblib.dll (V2000.80.194.0) in the C:\xampplite\apache\bin folder (rename the old one before). Apache will now use this driver instead of the 2000 version (V2000.2.8.0) and you can now restart the Apache server

Also Verify the port number of the SQL Server 2005 instance in the network configuration. This port must be static.

Hope this helps

[ruello]

I found this article on µsoft site: Accessing SQL Server Databases with PHP http://technet.microsoft.com/en-us/libr ... 93139.aspx