SAS ODBC System DSN connection failure in Azure Data Factory

Maicfel — Wed, 15 Apr 2026 12:25:37 GMT

I have an environment with SAS 9.4 M6 configured to use the SAS/SHARE service. On the client side, I am using Windows Server 2025 with the SAS ODBC driver version 9.404.00.16315 installed for connection via Databricks.

When configuring the connection in the ODBC Data Source Administrator as a System DSN using the mentioned SAS ODBC driver, the connection does not work.

On the other hand, when configuring it as a User DSN (both 32-bit and 64-bit), the connection is successfully established. In this scenario, I am able to test via PowerShell and retrieve data normally, for example by querying the table sashelp.buy, as evidenced in the tests performed.

When I perform the test directly in 64-bit PowerShell, executed via Azure Data Factory, the following error occurs.

PS C:\Users\cybgwdatasupp01\Desktop> C:\Users\cybgwdatasupp01\Desktop\TestSAS.ps1
Exception calling "Open" with "0" argument(s): ""
At C:\Users\cybgwdatasupp01\Desktop\TestSAS.ps1:6 char:1
+ $connection.Open()
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : OdbcException

Errors         : {}
Source         :
ErrorCode      : -2146232009
Message        :
Data           : {}
InnerException :
TargetSite     : Void HandleError(System.Data.Odbc.OdbcHandle, RetCode)
StackTrace     :    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 CallSite.Target(Closure , CallSite , Object )
HelpLink       :
HResult        : -2146232009

Exception calling "Open" with "0" argument(s): ""

topic SAS ODBC System DSN connection failure in Azure Data Factory in Administration and Deployment

SAS ODBC System DSN connection failure in Azure Data Factory