Hello everybody, I would like to access a Microsoft SQL database thorugh SAS, but do receive the following error after running the commands. A connection to the database through Windows ODBC driver is no problem at all. A connection via Excel is also working. So the user and database is working. Just through SAS I get the following messages: When I try it with a 'proc sql' statement: "The ODBC engine cannot be found etc" "A connection to the ODBC DBMS is currently not supported, or it is not installed at your site" "ERROR: Java repository file(s) are missing or inaccessible." "ERROR: Unable to initialize the ODS classpath during SAS startup." "ERROR: Exception text: For one or more plug-in requests, no matching Plug-ins were found in Repository" Trying to connect via 'libname' statement is also not possible. Similar error codes. I searched a lot for it, but haven't found a solution yet. I think it might be a problem with the license or installation. Is the module "SAS/ACCESS Interface to Microsoft SQL database" or "to ODBC" mandatory to perform these operations? OS: Microsoft Windows 7 x64 Output PROC SETINIT: Current version: 9.04.01M5P091317 Product expiration dates: ---Base SAS Software ---SAS/STAT ---SAS/GRAPH ---SAS/Secure 168-bit ---SAS/Secure Windows ---SAS Enterprise Guide ---SAS/ACCESS Interface to DB2 ---SAS Workspace Server for Local Access ---High Performance Suite Output PROC PRODUCT_STATUS For Base SAS Software ... Custom version information: 9.4_M5 Image version information: 9.04.01M5P090617 For SAS/STAT ... Custom version information: 14.3 For SAS/GRAPH ... Custom version information: 9.4_M5 For High Performance Suite ... Custom version information: 2.2_M6 For SAS/ACCESS Interface to DB2 ... Custom version information: 9.4_M2 Thanks and best Regards
... View more
