Problem Note 9478: SAS/Access to ODBC accessing Sql Server 2000 generates errors when
creating a temporary table
When using SAS 8.2 on Windows with SAS/Access to ODBC to Sql Server
2000, and trying to create a temporary table (#t1) on the Sql Server
database, you may receive the following error:
ERROR: CLI open cursor error: [Microsoft][ODBC SQL Server Driver]
[SQL Server] There is already an object named '#t11' in the database.
This error still occurs after issuing an "execute (drop table #t1)", so
from the tracing it appears that we are executing the statement twice,
once during the prepare and once during the fetch.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#009478
This is fixed in SAS V9.1.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows XP Professional | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | 9.1 TS1M0 |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | 9.1 TS1M0 |
*
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: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
|
| Date Modified: | 2003-06-27 12:17:08 |
| Date Created: | 2003-02-21 14:48:19 |
