Establishing connection from snowflake (DSN) to Spotfire(Version 10.4)Desktop I am getting error .Pls can any one suggest resolve problem

[Abhishek Patil]

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.d__37.MoveNext()

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

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

 

OdbcException at :

ERROR [HY000] [snowflake][snowflake] (4)

REST request for URL https://vu66182.eu-central-1.snowflakecomputing.com:443/session/v1/login... failed: CURLerror (curl_easy_perform() failed) - code=5 msg='Couldn't resolve proxy name' osCode=9 osMsg='Bad file descriptor'.

 

ERROR [HY000] [snowflake][snowflake] (4)

REST request for URL https://vu66182.eu-central-1.snowflakecomputing.com:443/session/v1/login... failed: CURLerror (curl_easy_perform() failed) - code=5 msg='Couldn't resolve proxy name' osCode=9 osMsg='Bad file descriptor'.

(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.b__0()

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

at Spotfire.Dxp.Data.Import.DatabaseDataSource.d__23.MoveNext()

at Spotfire.Dxp.Data.DataSourceConnection.d__37.MoveNext()

[Khushboo Rabadia]

It may be due to proxy setup error in snowflake env. Below are some posts:

https://support.snowflake.net/s/question/0D50Z000089HPyxSAG/unable-to-connect-to-snowflake-using-odbc-from-a-windows-machine

https://community.snowflake.net/s/question/0D50Z00008dUfhSSAS/why-code7-msgcouldnt-connect-to-server-oscode10060-osmsgunknown-error

As a test, you can try the same connection using third party tools like dbvisualizer, rapid sql to see if the connection to snowflake env is successful or not.