Problem Note 48877: A pass-through connection invokes the Data Link Properties dialog box even though an assigned OLEDB libref is also present
An OLEDB LIBNAME is assigned, but when the libref is referenced
in a subsequent SQL procedure pass-through step, the Data Link Properties dialog box is invoked.
libname mydb oledb
provider=sqloledb properties=("User ID"=user
Password=password "Data Source"=ServerName)
oledb_services=no bulkload=yes schema=schema;
proc sql;
connect using mydb;
create table work.test as select * from connection to mydb
(select * from SQLTable);
disconnect from mydb;
quit;
Currently, the OLE DB connection parameters must be specified in the CONNECT statement.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft® Windows® for x64 | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2003 for x64 | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows Server 2008 for x64 | 9.3 | | 9.3 TS1M0 | |
| Microsoft Windows XP Professional | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Enterprise 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Enterprise x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Home Premium 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Home Premium x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Professional 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Professional x64 | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Ultimate 32 bit | 9.3 | | 9.3 TS1M0 | |
| Windows 7 Ultimate x64 | 9.3 | | 9.3 TS1M0 | |
| Windows Vista | 9.3 | | 9.3 TS1M0 | |
| Windows Vista for x64 | 9.3 | | 9.3 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 |
| Date Modified: | 2013-07-19 14:27:49 |
| Date Created: | 2013-01-09 12:13:13 |
