Driver | Database/ Adapter IS Operating System/ Platform Affected | Limitation Description |
Microsoft JDBC Driver Version 2.2.0019 for Microsoft SQL Server 2000 | Microsoft SQL Server 2000 | When running the SelectSQL adapter service using the "not null real" type, the following error appears: Value cannot be converted to requested type. This is a driver issue for both the DataDirect Connect for JDBC and the Microsoft SQL Server 2000 Driver for JDBC. This driver does not support retrieving table names from a database when the database’s name contains special characters. This driver must have Oracle's JDK 1.3 package javax.sql.* in the Integration Server CLASSPATH before you can enable the adapter connection. If this package is missing, the following error appears: unable to configure connection manager javax/sql/DataSource. |
Microsoft JDBC Driver Version 1.0.809.102 for Microsoft SQL Server 2005 | Microsoft SQL Server 2005 | This driver returns incorrect data type TEXT, IMAGE, and NTEXT for MS SQL data types VARCHAR(max), VARBINARY(max) and NVARCHAR(max) respectively. This driver returns invalid JDBC data type for MS SQL UNIQUEIDENTIFIER data type. |
DataDirect Connect | Microsoft SQL Server 2000 | When running the SelectSQL adapter service using the "not null real" type, the following error appears: Value cannot be converted to requested type. |