SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 16337: SAS/ACCESS® Interface to OLE DB does not support the DBTYPE_VARIANT data type

DetailsHotfixAboutRate It

When you use SAS/ACCESS Interface to OLE DB to access a DBMS table that contains a column whose data type is DBTYPE_VARIANT, the following error will be returned:

ERROR: At least one of the columns in this DBMS table has a datatype
that is not supported by this engine.

To determine if any of your columns are of this type, submit the following SQL procedure:

proc sql; connect to oledb(...connection-info); create table work.cols as select * from connection to oledb(OLEDB::Columns,,table_name); quit;

Once this code runs, open the SAS data set WORK.COLS. The DATA_TYPE for a variant field is 12.

As a workaround, either change the data type or pass the DBMS-specific query that would convert this data type to a type (such as CHAR) that is supported.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to OLE DBMicrosoft Windows Server 2003 Standard Edition9.1 TS1M39.2 TS2M3
Microsoft Windows XP Professional9.1 TS1M39.2 TS2M3
Microsoft Windows 2000 Server9.1 TS1M3
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M39.2 TS2M3
Microsoft Windows 2000 Advanced Server9.1 TS1M3
Microsoft Windows 2000 Datacenter Server9.1 TS1M3
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M39.2 TS2M3
Microsoft Windows 2000 Professional9.1 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.