Error while configuring - Oracle Client data provider.

Error while configuring - Oracle Client data provider.

Error suggests that a 32-bit Oracle client is installed on the 64-bit Windows machine in which the TIBCO Spotfire Analyst is installed on, and that is causing this issue. Below is the detailed error message:

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

ImportException at Spotfire.Dxp.Forms:
Unable to connect to data source. (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.CreateConfiguredDataSourceFromDatabase()
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.CreateDataSources(DataSourceType dataSourceType, String errorDialogTitle, String fileOpenDialogTitle, DataSourceFactory dataSourceFactory, String initialDirectory, Boolean showOnDemandButtonInInformationLinkPrompt)

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.Forms.Data.Import.DataSourceFactoryService.CreateConfiguredDataSourceFromDatabase()

InvalidOperationException at System.Data.OracleClient:
Attempt to load Oracle client libraries threw BadImageFormatException.  This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. (HRESULT: 80131509)

Stack Trace:
   at System.Data.OracleClient.OCI.DetermineClientVersion()
   at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName)
   at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions)
   at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OracleClient.OracleConnection.Open()
   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<>c__DisplayClass8.<GetPromptModels>b__4()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)
   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<GetPromptModels>d__a.MoveNext()
   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__2.MoveNext()

BadImageFormatException at System.Data.OracleClient:
An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) (HRESULT: 8007000B)

Stack Trace:
   at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset)
   at System.Data.OracleClient.OCI.DetermineClientVersion()
--------------------------------------------------------------------- The typical solution is to install the Oracle Client for 64-bit Windows, instead of the 32-bit client. http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html