User`s guide

Fetching Data Common Errors
3-7
Fetching Data Common Errors
This table describes how to address common errors you might encounter while working
with Database Toolbox. These errors might occur in either Database Explorer or the
command line when using exec or fetch.
Vendor Error Message Probable Causes Resolution
Microsoft SQL
Server
The statement did
not return a result
set.
There are other
SQL statements in
the middle of the
stored procedure.
This error happens
after executing exec
but before executing
fetch. This error
happens only with
the command line.
Add 'SET NOCOUNT
ON' at the beginning
of your stored
procedure. For
details, see exec.
Microsoft SQL
Server
JDBC Driver 3.0
returns incorrect
date values when
used with JRE™
1.7 by a Java
application.
There is an issue
with the Microsoft
SQL Server JDBC
Driver 3.0. This
error happens after
executing fetch.
This error happens
either with Database
Explorer or the
command line.
Install a hotfix
from Microsoft
for JDBC Driver
3.0. Alternatively,
upgrade your
Microsoft SQL
Server JDBC driver
to version 4.0.
Microsoft SQL
Server
Connection is busy
with results for
another command.
You are connecting
to Microsoft SQL
Server using a driver
that preview does
not support.
Connect to Microsoft
SQL Server using
the JDBC driver.
Oracle Stored procedures
and functions return
result sets as cursor
types.
The JDBC driver
returns stored
procedure and
function result
sets as custom
Java objects. This
Write custom
MATLAB code
to process the
Java objects into
MATLAB variables.