SqlServerIntegration

Install SQL Server JDBC Driver

To use STIQ with SQL Server, you will need a JDBC driver that communicates with SQL Server.

STIQ has been tested with version 2.0 of Microsoft's SQL Server JDBC Driver. To install it:

Download the JDBC driver from here: http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9
Install (unzip) the driver package
Locate "sqljdbc.jar" in the extracted package (e.g., C:\Temp\sqljdbc_2.0.1803.100_enu\sqljdbc_2.0\enu\sqljdbc.jar).
Copy sqljdbc.jar into STIQ's "lib" directory (typically C:\Program Files\SolutionsIQ\StoryTestIQ\bin\lib).
Add the jar to the java classpath used when starting STIQ. For example, if you are using the "My Project" shortcut to launch STIQ, edit the "run_stiq_project.bat" file (typically in C:\Program Files\SolutionsIQ\StoryTestIQ):
- java -cp ".;bin/storytestiq.jar;bin/lib/commons-dbcp-1.2.2.jar;bin/lib/commons-pool-1.3.jar;bin/lib/h2-1.0.76.jar;bin/lib/sqljdbc.jar" fitnesse.FitNesse -o -p 9999 -r repository

Edit STIQ's storytestiq.properties file (typically in C:\Program Files\SolutionsIQ\StoryTestIQ) so it has the proper connection information.

See Microsoft's help for more information about configuring a JDBC connection: http://msdn.microsoft.com/en-us/library/ms378428.aspx