We've set up a Sharepoint 2010 system on Windows Server 2008 R2. I'd like to set up Excel Services, so we can create dashboards to our back-end databases, which are Oracle. I'm struggling to get the data connection to work.
To do this, should I be setting up my DSN with the 32-bit ODBC Oracle drivers, or the 64-bit ODBC Oracle drivers? Looking at the Excel Services setup, I think that the the list of trusted data sources provided are the 32-bit ODBC drivers. I did
install the 32-bit ODBC oracle drivers, and set up the DSN I needed. When I log in to the Sharepoint server via RDC and load the Excel spreadsheet, the data connection works fine. But, when I use Excel Services to create a dashboard, and refresh the data connection,
I get "Unable to refresh data for a data connection in the workbook." Looking at the Sharepoint log files, I see (password removed):
The Connection Information is invalid: ConnectionString: DSN=nifoem;UID=sp_oem;PWD=[XXX];SERVER=nifoem;, CredentialsMethod: Integrated, SSOApplicationId: , QueryType: Odbc bd9d6ef3-6097-4ed5-9b8a-ffafc3997d26
Any idea what I might be doing wrong here?
View Complete Post