Problem Note 6001: Access Interface to OLEDB will fail when attempting to call a stored
procedure with 'command was not prepared'
When using SAS/ACCESS Interface to OLEDB you may get the following error
if you are attempting to execute a stored procedure through PROC SQL
Pass-through:
ERROR: Describe error: Command was not prepared.
Below is code that would cause the problem:
PROC SQL;
CONNECT TO OLEDB(PROVIDER=..............);
SELECT * FROM CONNECTION TO OLEDB((CALL SP_HELP));
DISCONNECT FROM OLEDB;
QUIT;
Currently there is no workaround for this problem.
A Technical Support hot fix for Release 8.2 TSLEVEL 2M0 for this
problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006001
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#006001
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows 2000 Professional | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows NT Workstation | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 95/98 | 8.1 TS1M0 | 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: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> OLEDB
SAS Reference ==> LIBNAME Engines
Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database)
|
| Date Modified: | 2002-04-23 14:54:31 |
| Date Created: | 2001-10-05 09:54:57 |
