Problem Note 6278: "ERROR: The maximum number of DBMS opens for this engine has been
reached"
When using the SAS/ACCESS Interface to ODBC you may encounter the
following error:
ERROR: DBMS table open failed. The maximum number of DBMS opens for this
engine has been reached.
The error can occur when you have a view to an ODBC dsn and you access
the view several times in a row.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006278
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#006278
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows 95/98 | 8.2 TS2M0 | 8.2 TS2M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows NT Workstation | 8.2 TS2M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | 8.2 TS2M0 |
*
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: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2004-02-16 15:45:16 |
| Date Created: | 2001-11-14 11:21:02 |
