SAS files not opening in 7.5

Hello Everyone,

 

I am facing issue while opening SAS file (.sas7bdat) from analyst tool. I have installed the latest 64 bit version SAS Drivers for ODBC . Spotfire version is 7.5.

 

Here is error message:

 

Error message: Could not open data source.
TargetInvocationException at Spotfire.Dxp.Framework:Exception has been thrown by the target of an invocation. (HRESULT: 80131604)
Stack Trace:   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgressCancelable(String title, String description, ProgressOperation operation, Boolean showCancelButton)   at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgress(String title, String description, ProgressOperation operation)   at Spotfire.Dxp.Application.RichAnalysisApplication.Open(String filePath, DocumentOpenSettings documentOpenSettings)   at Spotfire.Dxp.Forms.Application.FileUserActions.LoadFileCallback(LoadCallbackParameters parameters)   at Spotfire.Dxp.Forms.Framework.Utilities.LoadFileHelper.LoadFile(LoadCallback callback, LoadCallbackParameters parameters, Form owningForm)

ImportException at Spotfire.Dxp.Data:Failed to execute data source query. (HRESULT: 80131500)
Stack Trace:   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()   at Spotfire.Dxp.Data.DataSource.Connect(IServiceProvider serviceProvider, DataSourcePromptMode promptMode, Boolean updateInternalState)   at Spotfire.Dxp.Application.AnalysisApplication.<OpenDocumentFile>d__8.MoveNext()   at Spotfire.Dxp.Forms.Application.FormsApplicationThread.<>c__DisplayClass1.<ExecutePromptingOperation>b__0()   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

ImportException at Spotfire.Dxp.Data:Unable to open OLE DB connection.ConnectionString = 'Provider=sas.LocalProvider;Data Source="C:\";SAS File Format=V9'. (HRESULT: 80131500)
Stack Trace:   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute(Action f)   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.TryExecute[T](Func`1 f)   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.<GetPromptModelsCore>d__24.MoveNext()   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()

ImportException at Spotfire.Dxp.Data:Unable to open OLE DB connection.ConnectionString = 'Provider=sas.LocalProvider;Data Source="C:\";SAS File Format=V9'. (HRESULT: 80131500)
Stack Trace:   at Spotfire.Dxp.Data.Import.SasFileDataReader..ctor(SasFileDataSourceSettings settings)   at Spotfire.Dxp.Data.Import.SasFileDataSource.<GetPromptModels>d__0.MoveNext()   at Spotfire.Dxp.Data.Import.SasFileDataSource.<GetSerializablePromptModels>d__5.MoveNext()   at Spotfire.Dxp.Data.Import.DataSourceOutOfProcessConnection.CallbackConnection.<GetPromptModelsCore>d__0.MoveNext()   at Spotfire.Dxp.Data.Import.OutOfProcessDataSourceConnection.SubprocessImpl..ctor(String[] args)

COMException at Provider:Accessor is invalid. (HRESULT: 80040E00)
Stack Trace:   at Microsoft.Interop.ADO.Field.get_Value()   at Spotfire.Dxp.Data.Import.SasFileDataReader.GetFormatString(Connection connection, String tableName)   at Spotfire.Dxp.Data.Import.SasFileDataReader.Initialize(Connection connection, String tableName, String sasFormat)   at Spotfire.Dxp.Data.Import.SasFileDataReader..ctor(SasFileDataSourceSettings settings)

Any help would be appreciated.

 

Thanks,

Amit 

(1) Answer

Login