Question on Excel Services – I’m using a third party ODBC driver – works great in Excel. Installed and configured the driver/ODBC on all web front ends (and the Office Web Apps servers too – just in case). The workbook is in a trusted location. The credentials are stored in the ODBC connection.
If I use ODBC in Excel nothing is logged (verbose logging enabled).
If I use OLE then it throws this: Failed to create an external connection or execute a query. Provider message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have a feeling this may have to do with the trusted providers but everything I try fails.
Here is the post I wrote, wish I had time to put in more details but if anyone needs more info, reply to this: http://www.mgtechgroup.com/2013/10/using-rssbus-odbc-drivers-with-excel-services-in-sharepoint-2013/
Â
