Usage Note 24545: Selecting File > Open > ODBC to open a DBMS table in SAS Enterprise Guide but unable to open the table
When you click File > Open > ODBC (ODBC-ICON), the SAS/ACCESS Interface to ODBC is not being used; Microsoft's ADO data access layer is being used. In order for SAS Enterprise Guide to process a task or query by using ODBC-ICON, it must first copy the data to the SAS Enterprise Guide client computer. For large volumes of data, this process can be slow. If you create a library that uses SAS/ACCESS or a database engine on the SAS server, SAS Enterprise Guide does not need to copy the data to the client computer.
To see if you have a SAS/ACCESS product on the SAS server, run the following code:
proc setinit noalias;
run;
To define a libref, execute the following LIBNAME statement from a code window in SAS Enterprise Guide:
libname odbclib odbc dsn=your_DSN_name user=YourUserID password=YourPW;
To access the data from SAS Enterprise Guide after the preceding libref is defined, go to: View > Server List > Server > Libraries > odbclib > then select a table to open.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Windows | | | n/a | |
| OpenVMS Alpha | | | n/a | |
| ABI+ for Intel Architecture | | | n/a | |
| Tru64 UNIX | | | n/a | |
| Linux on Itanium | | | n/a | |
| Linux | | | n/a | |
| 64-bit Enabled Solaris | | | n/a | |
| Solaris | | | n/a | |
| HP-UX | | | n/a | |
| HP-UX IPF | | | n/a | |
| 64-bit Enabled HP-UX | | | n/a | |
| 64-bit Enabled AIX | | | n/a | |
| AIX | | | n/a | |
| Microsoft Windows 2000 Advanced Server | 4.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 4.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 4.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 4.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.1 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 4.1 | | 9.1 TS1M3 SP4 | |
*
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: | Usage Note |
| Priority: | low |
| Date Modified: | 2008-02-19 14:08:21 |
| Date Created: | 2006-10-09 18:36:29 |
