Here are a couple of tips when using the Microsoft JDBC driver
1. There are docs that incorrectly specify the driver class name.
This is the correct class name:
Correct Class name: note sqlserver.jdbc not jdbc.sqlserver
<JDBCClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</JDBCClassName>
Using the class name shown in the doc will give you the infamous
JDBC driver not found error
This is the link to the latest Microsoft JDBC driver:
http://www.microsoft.com/en-ca/download/details.aspx?id=11774
2. If you get the following error when creating Crystal Reports using the JDBC driver for Microsoft Sql Server Database based on stored procedures:
Failed to retrieve data from the database
Details: Exception: [Error Message: ]null
Add the statement
set nocount on
to the stored procedure. This error is caused by the the row count being sent back as part of the result set.
IP Logged