Step 1: Download the JDBC SQL Server Driver<\/h3>\n
You need to download the JDBC SQL Server Driver. You can get it at Microsoft JDBC Drivers for SQL Server<\/a>.<\/p>\n The DBFit FAQ<\/a> includes the following info:<\/p>\n Deploy the JAR in the same folder as dbfit-XXX.jar. If you specify the full JDBC connection string explicitly, use Microsoft\u2019s driver in JDBC URL. DbFit does not support 3rd party SQL Server drivers at the moment.<\/p><\/blockquote>\n To be more specific this means that once you've downloaded the JDBC driver and unzipped them, find the file called sqljdbc4.jar and copy it into the DBFit directory called \"lib\" (..\\DBFit\\lib\\)<\/p>\n If it's missing you'll see a mess of an error message like this:<\/p>\n If you are connecting to a named instance of SQL Server then the next step is to make sure that SQL Server Browser service is running. You should already have it installed, just go to Services (press the Windows Button+R and type services.msc). Right click on SQL Server Browser\u00a0 and select \"Start\".<\/p>\n If the SQL Server Browser Service is not running you'll see the following message:<\/p>\n If like most of us you're using integrated security with SQL Server you'll need to add the sqljdbc_auth.dll into your java directory. Go back to the\u00a0 your sqljdbc_6.0 directory and track down sqljdbc_auth.dll. Mine was in the following location: ..\\sqljdbc_6.0\\enu\\auth\\x86 . Copy sqljdbc_auth.dll into your java bin directory. The path for mine was C:\\Program Files (x86)\\Java\\jre1.8.0_91\\bin.<\/p>\ndbfit.SqlServerTest\r\n\r\njava.lang.Error: Cannot load SqlServer database driver com.microsoft.sqlserver.jdbc.SQLServerDriver. Is the JDBC driver on the classpath?\r\n\tat dbfit.api.DbEnvironmentFactory$EnvironmentDescriptor.checkDriver(DbEnvironmentFactory.java:45)\r\n\tat dbfit.api.DbEnvironmentFactory$EnvironmentDescriptor.createEnvironmentInstance(DbEnvironmentFactory.java:60)\r\n\tat dbfit.api.DbEnvironmentFactory.createEnvironmentInstance(DbEnvironmentFactory.java:102)\r\n\tat dbfit.api.DbEnvironmentFactory.newEnvironmentInstance(DbEnvironmentFactory.java:106)\r\n\tat dbfit.SqlServerTest.(SqlServerTest.java:5)\r\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\n\tat sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\r\n\tat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)\r\n\tat java.lang.reflect.Constructor.newInstance(Unknown Source)\r\n\tat java.lang.Class.newInstance(Unknown Source)\r\n\tat fit.FixtureClass.newInstance(FixtureClass.java:24)\r\n\tat fit.FixtureLoader.instantiateFixture(FixtureLoader.java:62)\r\n\tat fit.FixtureLoader.instantiateFirstValidFixtureClass(FixtureLoader.java:84)\r\n\tat fit.FixtureLoader.disgraceThenLoad(FixtureLoader.java:44)\r\n\tat fit.Fixture.loadFixture(Fixture.java:142)\r\n\tat fit.Fixture.getLinkedFixtureWithArgs(Fixture.java:134)\r\n\tat fit.Fixture.doTables(Fixture.java:79)\r\n\tat fit.FitServer.process(FitServer.java:81)\r\n\tat fit.FitServer.run(FitServer.java:56)\r\n\tat fit.FitServer.main(FitServer.java:41)\r\nCaused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver\r\n\tat java.net.URLClassLoader.findClass(Unknown Source)\r\n\tat java.lang.ClassLoader.loadClass(Unknown Source)\r\n\tat sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)\r\n\tat java.lang.ClassLoader.loadClass(Unknown Source)\r\n\tat java.lang.Class.forName0(Native Method)\r\n\tat java.lang.Class.forName(Unknown Source)\r\n\tat dbfit.api.DbEnvironmentFactory$EnvironmentDescriptor.checkDriver(DbEnvironmentFactory.java:43)\r\n\t... 19 more\r\n\r\n<\/pre>\n
Step 2: Make sure SQL Server Browser is running<\/h3>\n
Query\r\n\r\njava.lang.IllegalArgumentException: No open connection to a database is available. Make sure your database is running and that you have connected before performing any queries.\r\n\tat dbfit.api.AbstractDbEnvironment.checkConnectionValid(AbstractDbEnvironment.java:237)\r\n\tat dbfit.api.AbstractDbEnvironment.getConnection(AbstractDbEnvironment.java:162)\r\n\tat dbfit.api.AbstractDbEnvironment.createStatementWithBoundFixtureSymbols(AbstractDbEnvironment.java:108)\r\n\tat dbfit.fixture.Query.getDataTable(Query.java:43)\r\n\tat dbfit.fixture.RowSetFixture.doRows(RowSetFixture.java:92)\r\n\tat fit.Fixture.doTable(Fixture.java:156)\r\n\tat fitlibrary.traverse.AlienTraverseHandler.doTable(AlienTraverseHandler.java:21)\r\n\tat fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:104)\r\n\tat fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:89)\r\n\tat fitlibrary.DoFixture.interpretWholeTable(DoFixture.java:73)\r\n\tat fitlibrary.suite.InFlowPageRunner.run(InFlowPageRunner.java:27)\r\n\tat fitlibrary.DoFixture.interpretTables(DoFixture.java:42)\r\n\tat dbfit.DatabaseTest.interpretTables(DatabaseTest.java:26)\r\n\tat fit.Fixture.doTables(Fixture.java:81)\r\n\tat fit.FitServer.process(FitServer.java:81)\r\n\tat fit.FitServer.run(FitServer.java:56)\r\n\tat fit.FitServer.main(FitServer.java:41)\r\n<\/pre>\n
Step 3: add the sqljdbc_auth.dll<\/h3>\n
![\"DBFit](\"http:\/\/www.sqldbpros.com\/wordpress\/wp-content\/uploads\/2016\/06\/DBFit_SQLServer_JDBC.png\")
<\/p>\n