User`s guide

3 Working with Data Sources
3-14
Database Explorer Error Messages
This table describes how to address common errors you might encounter while working
with Database Explorer. For details about Database Toolbox connection errors, see
“Database Connection Error Messages” on page 3-9.
Database Explorer Error Messages and Probable Causes
Vendor Error
Location
Error Message Probable Causes Resolution
All
JDBC-
Compliant
Databases
Error
occurs
in the
Connection
Failure
dialog
box after
clicking
Connect
in the
Connect
to a
Data
Source
dialog
box.
[Microsoft][ODBC
Driver Manager] Data
source name not found
and no default driver
specified
JDBC data sources
created by Visual
Query Builder
cannot be used in
Database Explorer.
You must run this
command:
setdbprefs(...,
'JDBCDataSourceFile',...
'')
Then, create a new
JDBC data source
from Database
Explorer.
Microsoft
SQL
Server
Error
occurs in
the Data
Preview
Error
dialog
box after
selecting
a
column
of a
table
in the
Invalid Object Name
catalog name.table
name
The selected schema
name in Database
Explorer is incorrect.
You must select the
appropriate schema
name in Database
Explorer using the
Catalog/Schema
address bar above the
table columns tree.