Unable to coneect to Jira MSSQL DB via TL 1.8

1.8 related questions and discussions.
Please upgrade to LATEST 1.9.x.
No more fixes for 1.8.

Moderators: Amaradana, TurboPT, TL Developers

Locked
Jalgaonkar
TestLink user
Posts: 4
Joined: Fri May 08, 2009 9:42 pm

Unable to coneect to Jira MSSQL DB via TL 1.8

Post by Jalgaonkar »

Hello,

I am new to using Testlink and I have setup the new TL 1.8.2 and trying to integrate it with Jira. Jira DB is hosted on remote server, I think I have configured the custom_config.inc.php and jira.config.php correctly as per the manual. In the App, When I fail testcase, I do not get the icon for Bug tracking tool, also in logs I get the following error:
Please note that I can succesffuly connect to remote Jira DB via sql client on which Testlink is hosted. Please let me know if I am missing something.


[09/May/8 20:57:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: NYCCORPBUG01 - in D:\xampp\htdocs\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 511
[09/May/8 20:57:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in D:\xampp\htdocs\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 499
[09/May/8 20:57:20][ERROR][<nosession>][GUI]
Connect to Bug Tracker database fails!!! -
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Post by fman »

do your php have extension to connect to mssql enabled?
Jalgaonkar
TestLink user
Posts: 4
Joined: Fri May 08, 2009 9:42 pm

Post by Jalgaonkar »

Yes, In my php.ini file I have foll uncommented:
extension=php_mssql.dll
Jalgaonkar
TestLink user
Posts: 4
Joined: Fri May 08, 2009 9:42 pm

Post by Jalgaonkar »

This has been resolved. Thanks for the lead though. The problems was with PHP, it has older version of ntwdblilb.dll (2000.2.8.0) and it needs 2000.80.194.0 . Also this dll needs to be in all these foll directories for windows:

windows\system32
apache\bin
php
Locked