SQL Server 2005 ODBC Adapter Limitations

• Supported Types
• Common to All Operations
• Read Table
• Execute Select SQL
• Write Table
• Execute Update SQL
• Execute Stored Procedure
• Write by Loader
• Major Exceptions

Supported Types

• Yes: Supported.
• Limited: Supported with limitations.
• No: Not supported.

Common to All Operations

Specification Limits

Read Table

• Displaying table list
  • Tables that exist in schemas other than dbo will be displayed as "<schema name>.<table name>".
• NCHAR
  • The end of NCHAR is not filled with spaces. (Behavior like variable-length data)
• IMAGE
  • When the data is null, it is retrieved as 0 byte array (Binary type).
• XML, VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX)
  • Retrieved up to 32767 bytes.
• NTEXT
  • Characters other than ASCII cannot be handled. Character corruption occurs.
• The table name is case-insensitive even if it is enclosed with quotation marks.

Execute Select SQL

• NCHAR
  • The end of NCHAR is not filled with spaces. (Behavior like variable-length data)
• IMAGE
  • When the data is null, it is retrieved as 0 byte array (Binary type).
• XML, VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX)
  • Retrieved up to 32767 bytes.
• NTEXT
  • Characters other than ASCII cannot be handled. Character corruption occurs.

Write Table

• Displaying table list
  • Tables that exist in schemas other than dbo will be displayed as "<schema name>.<table name>".
• NCHAR
  • The end of NCHAR is filled with spaces. (Behavior like fixed-length data)
• XML, VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX)
  • Retrieved up to 32767 bytes.
• BIGINT
  • When BIGINT type is included in columns to write, batch update is not supported.
• TINYINT
  • When TINYINT type is included in columns to write, batch update is not supported.
• The table name is case-insensitive even if it is enclosed with quotation marks.


• In environment where the collation is SQL_Latin1_General_CP1_CI_AS, 2 byte characters written to nchar or nvarchar type column will be registered as “?”.

Execute Update SQL

• NCHAR
  • The end of NCHAR is filled with spaces. (Behavior like fixed-length data)
• XML, VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX)
  • Retrieved up to 32767 bytes.
• BIGINT
  • When BIGINT type is included in columns to write, batch update is not supported.
• TINYINT
  • When TINYINT type is included in columns to write, batch update is not supported.
• In environment where the collation is SQL_Latin1_General_CP1_CI_AS, 2 byte characters written to nchar or nvarchar type column will be registered as “?”.

Execute Stored Procedure

Write by Loader

Major Exceptions