Pentaho - statement did not return a result set

Using a TABLE INPUT with a Microsoft Sql Server procedure, I started getting this error message:

"statement did not return a result set"

After some googling and misleading forum threads, I found that the Java Driver was getting confused by the rowcount.

To solve this you need to add SET NOCOUNT ON; at the begining of your procedure.



Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06

Error connecting Pentaho with Azure: "Server name cannot be determined. It must appear as the first segment of the server's dns name..."

I was creating a ETL package with Pentaho and surprisingly I got this message while connecting to SQL Azure: "Server name cannot be determined.  It must appear as the first segment of the server's dns name (servername.database.windows.net).  Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername).  In addition, if both formats are used, the server names must match."

Reading the message closely, I decided to change the user name to a "user@servername" format, and that worked instantly.

This is unusual, given that a common SQL SERVER connection doesn't need that.

I'm using MS SQL SERVER (NATIVE) connection type (JDBC), and Pentaho 5.3.0.0-213.