New install (v1.8.3) to use existing MSSQL Database (v1.8.1)

[skells]

a few months ago, I setup v1.8.1 on one of my test machines in order to evaluate TestLink for use by our QA dept. After messing around with it for a while, I was able to get TestLink to create the testlink database on our QA MSSQL server.

After everyone tried it out and agreed to use this tool, we had our IT dept setup a server for the application and install 1.8.3 (to get the latest code). Now, from reading on the forums I felt I could copy config_db.inc.php from the install on my machine (which has the connection info for our existing db) and drop it into the inetpub\www\testlink directory on the new machine and that should eliminate the need for me to reconfigure the database. When I put that in my testlink directory and attempt to go to /testlink/index.php, I get a message:

------------------------
-
TestLink ::: Fatal Error
-
------------------------

Looking in the userlog0.log file, I see:

---------------------------------------
[>>][4a7348dcc56db669250941][DEFAULT][/testlink/index.php][09/Jul/31 19:41:16]
[<<][4a7348dcc56db669250941][DEFAULT][/testlink/index.php][09/Jul/31 19:41:16][09/Jul/31 19:41:17][took 0.182878 secs]
[>>][4a7348dd23c71539410243][DEFAULT][/testlink/login.php][09/Jul/31 19:41:17]
[09/Jul/31 19:41:17][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Jul/31 19:41:17][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Jul/31 19:41:17][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Jul/31 19:41:23][WARNING][<nosession>][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: ATQA03VSQL\ATQA03 - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 511
[09/Jul/31 19:41:23][WARNING][<nosession>][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 499
[09/Jul/31 19:41:23][ERROR][<nosession>][GUI]
Connect to database fails!!! -
[<<][4a7348dd23c71539410243][DEFAULT][/testlink/login.php][09/Jul/31 19:41:17][09/Jul/31 19:41:23][took 6.781373 secs]
[>>][4a7348e3e4751370911481][DEFAULT][/testlink/login.php][09/Jul/31 19:41:23]
[09/Jul/31 19:41:23][WARNING][<nosession>][GUI]
E_NOTICE
Undefined index: link_to_op - in C:\Inetpub\wwwroot\testlink\gui\templates_c\%%4A^4A2^4A2CD998%%workAreaSimple.tpl.php - Line 25
[09/Jul/31 19:41:23][ERROR][<nosession>][GUI]
Connection fail page shown.
[<<][4a7348e3e4751370911481][DEFAULT][/testlink/login.php][09/Jul/31 19:41:23][09/Jul/31 19:41:23][took 0.038925 secs]
[>>][4a7348ee83f36782543642][DEFAULT][/testlink/login.php][09/Jul/31 19:41:34]
[09/Jul/31 19:41:34][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Jul/31 19:41:34][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Jul/31 19:41:34][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Jul/31 19:41:40][WARNING][<nosession>][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: ATQA03VSQL\ATQA03 - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 511
[09/Jul/31 19:41:40][WARNING][<nosession>][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 499
[09/Jul/31 19:41:40][ERROR][<nosession>][GUI]
Connect to database fails!!! -
[<<][4a7348ee83f36782543642][DEFAULT][/testlink/login.php][09/Jul/31 19:41:34][09/Jul/31 19:41:40][took 5.650726 secs]
[>>][4a7348f430929798462043][DEFAULT][/testlink/login.php][09/Jul/31 19:41:40]
[09/Jul/31 19:41:40][WARNING][<nosession>][GUI]
E_NOTICE
Undefined index: link_to_op - in C:\Inetpub\wwwroot\testlink\gui\templates_c\%%4A^4A2^4A2CD998%%workAreaSimple.tpl.php - Line 25
[09/Jul/31 19:41:40][ERROR][<nosession>][GUI]
Connection fail page shown.
[<<][4a7348f430929798462043][DEFAULT][/testlink/login.php][09/Jul/31 19:41:40][09/Jul/31 19:41:40][took 0.01524 secs]
--------------------------------

If I rename config_db.inc.php to config_db.inc.php.old and try to go to /testlink/index.php, I get redirected to /testlink/install/index.php. If I click the link for New Installation and fill in the database information as recorded int the config_db.inc.php.old file, I get the message:

---------------------------------------
TestLink 1.8.3 Installation - new

TestLink setup will now attempt to setup the database:

Creating connection to Database Server: Failed!
Please check the database login details and try again.
Database Error Message:
---------------------------------------

I used the script in section 3.4 of the installation manual to see if I had any issues connecting to the database, but when i ran it it didn't give me any information (I will admit I am not a programmer and Googled my way though setting this up to work with IIS and php 5.2 and MSSQL the first time).

Can anyone enlighten me as to why moving the config_db.inc.php file wouldn't work as expected? Did I miss something basic (I am hoping)? Thanks!

~Skells

[skells]

I Need some help if anyone can provide it. I replaced the 1.8.3 install on my server with the 1.8.1 install to see if it was some incompatibility between the versions, but i still get the message:

------------------------
-
TestLink ::: Fatal Error
-
------------------------

and in the userlog0.log file I see:

------------------------
[09/Aug/17 17:40:03]
[09/Aug/17 17:40:03][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:40:03][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:40:03][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:40:09][WARNING][<nosession>][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: ATQA03VSQL - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 511
[09/Aug/17 17:40:09][WARNING][<nosession>][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 499
[09/Aug/17 17:40:09][ERROR][<nosession>][GUI]
Connect to database fails!!! -
[<<][4a8995f329921474753069][DEFAULT][/testlink/login.php][09/Aug/17 17:40:03][09/Aug/17 17:40:09][took 6.627772 secs]
[>>][4a8995f9c46fb155217216][DEFAULT][/testlink/login.php][09/Aug/17 17:40:09]
[09/Aug/17 17:40:09][WARNING][<nosession>][GUI]
E_NOTICE
Undefined index: link_to_op - in C:\Inetpub\wwwroot\testlink\gui\templates_c\%%4A^4A2^4A2CD998%%workAreaSimple.tpl.php - Line 25
[09/Aug/17 17:40:09][ERROR][<nosession>][GUI]
Connection fail page shown.
[<<][4a8995f9c46fb155217216][DEFAULT][/testlink/login.php][09/Aug/17 17:40:09][09/Aug/17 17:40:09][took 0.01336 secs]
[>>][4a8995fea474d230235508][DEFAULT][/testlink/login.php][09/Aug/17 17:40:14]
[09/Aug/17 17:40:14][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:40:14][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:40:14][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:40:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: ATQA03VSQL - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 511
[09/Aug/17 17:40:20][WARNING][<nosession>][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 499
[09/Aug/17 17:40:20][ERROR][<nosession>][GUI]
Connect to database fails!!! -
[<<][4a8995fea474d230235508][DEFAULT][/testlink/login.php][09/Aug/17 17:40:14][09/Aug/17 17:40:20][took 5.679301 secs]
[>>][4a89960457e60925913623][DEFAULT][/testlink/login.php][09/Aug/17 17:40:20]
[09/Aug/17 17:40:20][WARNING][<nosession>][GUI]
E_NOTICE
Undefined index: link_to_op - in C:\Inetpub\wwwroot\testlink\gui\templates_c\%%4A^4A2^4A2CD998%%workAreaSimple.tpl.php - Line 25
[09/Aug/17 17:40:20][ERROR][<nosession>][GUI]
Connection fail page shown.
[<<][4a89960457e60925913623][DEFAULT][/testlink/login.php][09/Aug/17 17:40:20][09/Aug/17 17:40:20][took 0.014846 secs]
[>>][4a8997082e38a814551683][DEFAULT][/testlink/install/installNewDB.php][09/Aug/17 17:44:40]
[09/Aug/17 17:44:40][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::PrepareSP() should be compatible with that of ADOConnection::PrepareSP() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:44:40][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaPrimaryKeys() should be compatible with that of ADOConnection::MetaPrimaryKeys() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:44:40][WARNING][<nosession>][GUI]
E_STRICT
Declaration of ADODB_mssql::MetaIndexes() should be compatible with that of ADOConnection::MetaIndexes() - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 735
[09/Aug/17 17:44:46][WARNING][<nosession>][GUI]
E_WARNING
mssql_connect() [<a href='function.mssql-connect'>function.mssql-connect</a>]: Unable to connect to server: atqa03vsql\atqa03 - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 511
[09/Aug/17 17:44:46][WARNING][<nosession>][GUI]
E_WARNING
mssql_query(): supplied argument is not a valid MS SQL-Link resource - in C:\Inetpub\wwwroot\testlink\third_party\adodb\drivers\adodb-mssql.inc.php - Line 499
[<<][4a8997082e38a814551683][DEFAULT][/testlink/install/installNewDB.php][09/Aug/17 17:44:40][09/Aug/1717:44:46][took 6.755255 secs]

~Skells

[prb75]

I'm also having the same problem and I'm struggling to resolve it.
I have tried down,lloading the latest version of adodb to no avail.

[skells]

With enough Google-grease, I was able to find a suggested solution for the errors I was having with adodb-mssql.inc.php connecting to my MSSQL server. The suggestion was to replace the ntwdblib.dll file in my php install with the latest version. Once I did that and restarted the machine, the install page connected to my db server just fine. I received a whole bunch of errors with the existing database (it didn;t like the drop and insert statements), but considering that the database I had for 1.8.1 was just an evaluation to see if we wanted to use this company wide, I just deleted the database and let it create a fresh one.

FYI, I am running PHP 5.2.10.10 on IIS 6.1 on Windows Server 2003, running MSSQL 2005 for our database.