CLI and ODBC errors occur when you use the SAS. No ODBC drivers are installed on the system.
You can check it by doing the following. If you have Office 2. Windows version of SAS, you can check whether you have a 3. Office by doing the following.
![Error Im002 Microsoft Odbc Driver Manager Data Source Name Not Found Error Im002 Microsoft Odbc Driver Manager Data Source Name Not Found](http://forums.attunity.com/forums/attachments/amazon-redshift-topics/340d1447092120-data-source-name-not-found-no-odbc.png)
This example uses Excel. Right- click on the service and select Stop. Section 3 - Uninstalling the SAS PC Files Server. If the SAS PC Files Server and Microsoft Office do not match, you can uninstall the SAS PC Files Server. The Windows user ID needs to have Administrative rights on the machine. Look in your services panel.
Shut down the SAS PC Files Server if it is still running from doing the steps in Section 2 of this SAS note. Click the Shutdown Server button. Select Start . Click Programs and Features. Double- click SAS 9.
In the Choose Language dialog box, select English or another language and click OK. Click the Clear All button. Make sure that all products are unchecked. Select the check box next to the SAS PC Files Server only. Click Next. The Tooling Initialization Complete panel appears.
Search by Item Number or Description: Copyright 2001 NXC Imaging. All Rights Reserved. Contact the Webmaster with any problems. Using an Excel data source, and receiving an error that says “Connection could not be validated”. When clicking on Details, the message says “ERROR
Then select the Next button. A stage 1 uninstall button appears. Click the Start button. Click This Program Uninstalled Correctly. Reboot your machine.
Cannot create an instance of OLE DB provider
After the machine has rebooted, go to Section 4, Installing the Matching SAS PC Files Server. Section 4 - Installing the Matching SAS PC Files Server.
The SAS 9. 3 PC Files Server can be downloaded from the following link. SAS PC Files Server 9.
The data source you are attempting to connect to does not exist on your machine. On Linux and UNIX, SYSTEM data sources are typically defined in /etc/odbc.ini.
Alternatively, you can do the following. Click support. sas. In the table, you see the two different SAS PC Files Servers that are available. Neither works with SAS 9. TS2. M3 or earlier versions of SAS. Click one of the versions, in accordance with the following: The Microsoft Windows for X6.
Office. Even if you are running an X6. Windows 7, do not choose this version if you are running the 3. Office. The Windows option is for 3. Office. If you are running 3. Office, choose this option. The 3. 2- bit version of Office requires the Windows version of the SAS PC Files Server.