@admin
@sasadmins
@Sasodbctest7
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): ""
