Section 2 - Checking the Version and Bit Architecture of the SAS PC Files Server If you have 32-bit Excel or you are running SAS on a UNIX host or remote host, continue with the installation process for the SAS PC Files Server.You can use DBMS=EXCEL instead of the SAS PC Files Server. If you have 64-bit Excel and you are running SAS for Windows, stop here, because you do not need the SAS PC Files Server.The version and bit architecture of Excel are shown on the right, under About Excel.If you have Office 2010 and you are running the 64-bit Windows version of SAS, you can check whether you have a 32-bit or 64-bit version of Office by doing the following: If you have Office 2003 or Office 2007, you have a 32-bit version of Office and should go to Section 2 of this SAS note. Section 1 - Checking Your Version of Microsoft Office Use the following instructions to check this. To circumvent the problem, first check the bit architecture of the SAS PC Files Server and Microsoft Office.
ODBC EXCEL DRIVER INVALID USE OF NULL DRIVERS
No ODBC drivers are installed on the system.The most common cause is that you have installed the 64-bit version of the SAS PC Files Server on a machine running the 32-bit version of Microsoft Office. The wrong SAS PC Files Server has been installed.ERROR: CLI error trying to establish connection: ĭata source name not found and no default driver specifiedĪny of the following can cause this problem:
0 kommentar(er)
