Problem Note 16740: "WARNING: No matching members in directory" using LIBNAME statement for
SAS/ACCESS Interface to OLE DB to access SQL Server with PROC DATASETS
The following may be returned when running PROC DATASETS on a SQL Server
database accessed from SAS using the LIBNAME OLE DB engine:
libname sqlserv oledb init_string="Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=True;
Initial Catalog=xxxx;
Data Source=abcdefghijklmnop";
proc datasets lib=sqlserv;
Directory
Libref SQLSERV
Engine OLEDB
Physical Name
Schema/Owner dbo
WARNING: No matching members in directory.
contents data=_all_;
run;
WARNING: No matching members in directory.
quit;
This message will be returned when the procedure is trying to access a
view which references a table in another database to which the user does
not have access to read.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to OLE DB | Microsoft Windows XP Professional | 9.1 TS1M3 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
*
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: | low |
Topic: | Data Management ==> Data Sources ==> External Databases ==> OLEDB Third Party ==> Information Exchange ==> OLE DB (Object Linking and Embedding Database) SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2006-01-10 10:59:24 |
Date Created: | 2005-12-26 13:55:46 |