Help connecting to ODBC data source using Oracle in instantclient_x64

[Jordan Christian]

I need help trying to connect Spotfire to and ODBC data source using the Oracle in instantclient_x64 driver. I can connect to the ODBC data source using Microsoft Access, but I cannot connect with Spotfire.  I can connect spotfire to other ODBC data sources that use other drivers, but not the Oracle in instantclient_x64.

I am using Spotfire version 10.3.3.11

 

 

 

Error message: Could not read the selected data.

AggregateException at :

One or more errors occurred. (HRESULT: 80131500)

 

Stack Trace:

Aggregated exception:

ImportException at Spotfire.Dxp.Data:

Failed to execute data source query for data source "". (HRESULT: 80131500)

Stack Trace:

   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()

   at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<GetPromptRequests>d__7.MoveNext()

   at Spotfire.Dxp.Data.Access.AddData.DataSourceAddDataFlow.ConfigureDataSourcesStep.<EnumerateModels>d__6.MoveNext()

OdbcException at :

ERROR [IM003] Specified driver could not be loaded due to system error  127: The specified procedure could not be found. (Oracle in instantclient_x64, C:\Oracle\product\19.0.0\instantclient_x64\SQORA32.dll). (HRESULT: 80131937)

 

Stack Trace:

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)

   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.Odbc.OdbcConnection.Open()

   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<>c__DisplayClass23_1.<GetPromptModels>b__0()

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

   at Spotfire.Dxp.Data.Import.DatabaseDataSource.<GetPromptModels>d__23.MoveNext()

   at Spotfire.Dxp.Data.DataSourceConnection.<GetPromptModels>d__37.MoveNext()

[David Boot-Olazabal]

Hi Jordan,

Are you trying to directly connect Spotfire to Oracle using an ODBC connector? Or are you trying to set up an ODBC DSN, which you then use in Spotfire to connect to Oracle?
Either way, it could be that you have to install the "VC++ 2010 Redistributable Package (x64)". I've seen a couple of similar support tickets for the same Spotfire version with other data sources trying to connect through ODBC, so this might be a good thing to start with.

I also wanted to point out, that Spotfire 10.3 is an unsupported version, so if nothing helps, you may need to upgrade to a higher Spotfire version.

Kind regards,

David