3 Replies Latest reply on Aug 23, 2013 7:41 AM by Ryan Brideau

    Trouble connecting to a saved Excel data source

    Joe Ward

      Hi,

       

      I'm having trouble connecting to a saved Excel data source in Tableau 8.  Nothing has changed with the file.  Nothing has changed with the connection.  I can click the "Download Copy" option on saved data source in Desktop and use it just fine.  Likewise, I can create a new data source with the same file and everything is fine.

       

      Here is the error I get:

       

      The drivers necessary to connect to this database server are not properly installed.  Visit http://www.tableausoftware.com/drivers to download driver setup files.

      The drivers necessary to connect to the database server '' are not properly installed on Tableau Server.  Visit http://www.tableausoftware.com/drivers to download driver setup files.

      Database error 0x80040154: Class not registered

       

      Unable to connect to the Microsoft Excel file "C:\ProgramData\Tableau\Tableau Server\data\tabsvc\temp\TableauTemp\03kyfqb0wh8iky12s7g0z059iiqz\Data\Data Sources\myFile.xlsx". Check that you have access privileges for the requested file and that it is not open in another application.

      create.xml

      class DataSourceException

      Unable to connect to the server "myServer". Check that the server is running and that you have access privileges to the requested database.

      Error: Unable to connect to this Tableau Server data source.

       

      Thanks