SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 56895: CLI OPEN CURSOR and OUT-OF-RANGE errors occur when you use date time literals with SAS/ACCESS® Interface to ODBC in a UNIX operating environment

DetailsHotfixAboutRate It

When you use date time literals in SAS/ACCESS Interface to ODBC under UNIX, the following errors might occur:

ERROR: CLI open cursor error: [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL 
Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range 
value.

Here is an example of code that can lead to the problem:

libname x odbc dsn=your_dsn" user=your_user pw=password dbconinit="set DATEFORMAT ydm" 
connection=sharedread ;

   data x;
      set x.test;
      where dt between "28OCT2015:09:00:00"dt and  "30OCT2015:11:59:59"dt;
   run;

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to ODBC64-bit Enabled AIX9.4 TS1M2
64-bit Enabled Solaris9.4 TS1M2
HP-UX IPF9.4 TS1M2
Linux for x649.4 TS1M2
Solaris for x649.4 TS1M2
* 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.