SQL Server 2008 ODBC Adapter Limitations

Supported Types

This adapter supports types as follows.

None

Table List View
- Table with schema other than dbo schema is shown as <schema name>.<table name>.
NCHAR
- Can get without pending spaces at the end. (Behavior similar to variable length)
IMAGE
- If data is null, get as zero-length byte array(binary type).
XML, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)
- Can get up to 32767 bytes.
NTEXT
- none ascii character cannot be used. Characters will be garbled.
Upper/lower case is not distinguished in table name even when table name is enclosed in quotation marks.

NCHAR
- Can get without pending spaces at the end. (Behavior similar to variable length)
IMAGE
- If data is null, get as zero-length byte array(binary type).
XML, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)
- Can get up to 32767 bytes.
NTEXT
- none ascii character cannot be used. Characters will be garbled.

Table List View
- Table with schema other than dbo schema is shown as <schema name>.<table name>.
NCHAR
- Padding with spaces (Behavior similar to fixed length)
DATETIME
- Batch update is not supported when the type of the column to write contains DATETIME type.
XML, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)
- Can write up to 32767 bytes.
BIGINT
- Batch update is not supported when the type of the column to write contains BIGINT type.
TINYINT
- Batch update is not supported when the type of the column to write contains TINYINT type.
SMALLDATETIME
- Batch update is not supported when the type of the column to write contains SMALLDATETIME type.
Upper/lower case is not distinguished in table name even when table name is enclosed in quotation marks.

In environment with collation of SQL_Latin1_General_CP1_CI_AS, if nchar type, nvarchar type column is written with double-byte characters, it is registered as "?".

NCHAR
- Padding with spaces (Behavior similar to fixed length)
DATETIME
- Batch update is not supported when the type of the column to write contains DATETIME type.
XML, VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX)
- Can write up to 32767 bytes.
BIGINT
- Batch update is not supported when the type of the column to write contains BIGINT type.
TINYINT
- Batch update is not supported when the type of the column to write contains TINYINT type.
SMALLDATETIME
- Batch update is not supported when the type of the column to write contains SMALLDATETIME type.
In environment with collation of SQL_Latin1_General_CP1_CI_AS, if nchar type, nvarchar type column is written with double-byte characters, it is registered as "?".

Execute Stored Procedure is not supported.

Write by loader is not supported.

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.