SQL Server 2005 ODBC Adapter Limitations

Supported Types

This adapter supports types as follows.

Type nameSupportRemarks
BIGINTLimited 
INTYes 
SMALLINTYes 
TINYINTLimited 
BITYes 
NUMERICYes 
DECIMALYes 
MONEYYes 
SMALLMONEYYes 
FLOATYes 
REALYes 
DATETIMEYes 
SMALLDATETIMEYes 
CHARYes 
VARCHARYes 
NCHARLimited 
NVARCHARLimited 
TEXTYes 
NTEXTLimited 
BINARYYes 
VARBINARYYes 
IMAGELimited 
VARCHAR (MAX)Limited 
NVARCHAR (MAX)Limited 
VARBINARY (MAX)Limited 
XMLLimited 

Common to all processing

Specification Limits

None

Read Table

Execute Select SQL

Write table

Execute Update SQL

Execute Stored Procedure

Execute Stored Procedure is not supported.

Write by Loader

Write by loader is not supported.

Main exceptions

Exception name Cause Actions
java.sql.SQLException [Microsoft] [ODBC Driver Manager] data source name and the specified default driver was not found. ODBC data source could not be found. Ensure the [ODBC data source name] specified is correct.
[Microsoft] [SQL Native Client] [SQL Server] user <username> Login failed. ] Connected to the database but cannot login. Check [User name]/[Password].
[Microsoft] [SQL Native Client] [SQL Server] The object name '<table name>' is invalid. "<table name>" does not exist. Make sure the specified table exists.
[Microsoft] [SQL Native Client] [SQL Server] Invalid syntax near '<table name>'. The table name may not follow the rules for standard identifiers of Transact-SQL. In that case, enclose the specified table name with quotation marks.