Problem Note 70800: Writing to Microsoft SQL Server fails with "ERROR: CLI describe error: [SAS][ODBC 20101 driver][Microsoft SQL Server]..."
 |  |  |  |  |
Errors might occur after you install the DataDirect ODBC Driver for Microsoft SQL Server 9.45 Hot Fix M2L005.
The first indication of this issue is that the error incorrectly includes the text "[SAS][ODBC 20101 driver][Microsoft SQL Server]". The remainder of the error message is typically not correct, but can include the following:
-
ERROR: CLI describe error: [SAS][ODBC 20101 driver][Microsoft SQL Server]Invalid object name 'TableName'.
: [SAS][ODBC 20101 driver][Microsoft SQL Server]The metadata could not be determined because every code path results in an error; see previous errors for some of these.
-
Using PROC SQL step to create a temporary table and load data into from this SAS Dataset fails with Error below.
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: [SAS][ODBC 20101 driver][Microsoft SQL Server]Line 1:Specified scale 27 is invalid.
The only workaround is to revert to a backup of your installation.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | Linux for x64 | 9.45 | 9.4 TS1M8 | ||
A fix for this issue for DataDirect ODBC Driver for Microsoft SQL Server 9.45 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/M2L.html#70800
Errors occur after installing DataDirect ODBC Driver for Microsoft SQL Server 9.45 Hot Fix M2L005.
| Type: | Problem Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS SQL Server |
| Date Modified: | 2024-06-13 08:32:46 |
| Date Created: | 2024-05-20 04:22:40 |