I am having an intermittent problem with a Spotfire Server accessing information models which connect to Microsoft Access databases via ODBC.
The server is a Windows Server 2008 R2 64bit, we have installed the 64bit ODBC Microsoft ACE ODBC drivers available from (http://www.microsoft.com/en-gb/download/details.aspx?id=13255).
The issue we are seeing is an error:
The data source reported a failure.
InformationModelException at Spotfire.Dxp.Data: Error retrieving metadata: [Microsoft][ODBC Driver Manager] Invalid string or buffer length (HRESULT: 80131500)
I've checked that the Spotfire Server is running in 64bit mode (its a java app running in Tomcat6), hence the 64bit drivers.
Has anyone else had and resolved a similar issue?