Why won't spotfire load a file from access that is linked to an SQL server

[Thomas Dowling]

I have an ODBC set up on my machine that both Microsoft Access and SPotfire are connected to. I run into issues when Itry to upload a data table query that wascreatedin an Access.db that is linked to an SQL Server through an ODBC that lives on my machine. If the data is brought into Access as a .csv, .xls. etc i do not run into any issues. Below is the error message i recieve from Spotfire.

 

Error message: Unable to import data. See the details for more information.

ImportException at Spotfire.Dxp.Data:

Unable to execute SQL statement: 'SELECT

`Prod Detail - Delaware`.*

FROM

`Prod Detail - Delaware`' (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.Import.OutOfProcessDataRowReader.TryExecute(Action f)

at Spotfire.Dxp.Data.Import.OutOfProcessDataRowReader.TryExecute[T](Func`1 f)

at Spotfire.Dxp.Data.Import.OutOfProcessDataRowReader..ctor(PartialDataLoadReport loadReport, Subprocess process, Stream inputStream, Stream errorStream, Boolean ownsStreamsAndProcess)

at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.ExecuteQueryCore2()

at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

at Spotfire.Dxp.Data.DataFlow.Execute()

at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.ExecuteQueryCore2()

at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.c__DisplayClass27.b__24()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.CreateView(CxxSession session, DataPropertyRegistry propertyRegistry, GlobalMethodRegistry globalMethodRegistry, DataSourceConnection connection, PartialDataLoadReport& partialLoadReport)

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.GetColumnsAndProperties(DataSourceConnection connection)

at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(SourceColumnProducer producer, DataSourceConnection connection)

at Spotfire.Dxp.Data.Persistence.DataItem.Update(SourceColumnProducer producer, DataSourceConnection connection)

at Spotfire.Dxp.Data.Persistence.DataPool.d__2.MoveNext()

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.OnConfigure()

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableListAvlLeaf`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableList`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass9.b__8(IDocumentNodeChild documentNodeChild)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.ForEachChild(IDocumentNodeChild[] children, Action`1 action)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation)

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew()

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNodeBase newOwner)

at Spotfire.Dxp.Framework.DocumentModel.UndoableNode.Spotfire.Dxp.Framework.DocumentModel.IUndoableNode.AttachItemToUndoableNode(Object item)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass6.b__5()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item)

at Spotfire.Dxp.Data.DataTableCollection.c__DisplayClass37.b__36()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException)

at Spotfire.Dxp.Data.DataTableCollection.Add(DataTable dataTable)

at Spotfire.Dxp.Data.DataTableCollection.Add(String dataTableName, DataSource dataSource, Boolean autoCreateFilters, Boolean includeInAxisControls)

at Spotfire.Dxp.Forms.Data.Import.TableContext.DataFlowBuilderContext.c__DisplayClass3.b__0()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)

at Spotfire.Dxp.Forms.Data.Import.TableContext.DataFlowBuilderContext.AddDataTables(DataManager dataManager, Form baseForm, List`1& addedTables, String& errorMessage)

 

ImportException at Spotfire.Dxp.Data:

Unable to execute SQL statement: 'SELECT

`Prod Detail - Delaware`.*

FROM

`Prod Detail - Delaware`' (HRESULT: 80131500)

Stack Trace:

at Spotfire.Dxp.Data.Import.DatabaseExtendedReader..ctor(String provider, String connectionString, String sqlStatement)

at Spotfire.Dxp.Data.Import.AccessFileDataSource.ExecuteQuery(QueryResultWriter writer, Int32 numRows)

at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.ExecuteQueryCore(QueryResultWriter resultWriter, Int32 maxRows)

at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)

 

OleDbException at Microsoft Access Database Engine:

ODBC--connection to 'BI Connect' failed. (HRESULT: 80004005)

Stack Trace:

at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)

at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)

at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)

at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)

at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)

at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)

at System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior)

at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

at Spotfire.Dxp.Data.Import.DatabaseExtendedReader..ctor(String provider, String connectionString, String sqlStatement)