Usage Note 17886: How to read XML data with the SQLNCLI OLE DB provider
Using the Microsoft SQL Native OLEDB provider (SQLNCLI) to read
XML data from SAS/ACCESS Interface to OLE DB may result in the XML
column being dropped as well as a NOTE as follows in the SAS log:
NOTE: The following 1 column(s) in libref.col have been automatically
dropped because they have a datatype that is not supported by
this engine
This is a Microsoft bug with the SQL native provider and can be resolved
by adding the following libname option:
provider_string="DataTypeCompatibility=80" oledb_services=no
The libname would look as follows:
libname x oledb provider=sqlncli uid=xxx pwd=xxx dsn=xxx
provider_string="DataTypeCompatibility=80" oledb_services=no;
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows XP Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.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.
| Type: | Usage Note |
| Priority: | low |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> OLEDB
Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database)
|
| Date Modified: | 2006-07-25 16:23:05 |
| Date Created: | 2006-06-15 15:13:19 |
