Database connectエラーで接続できない

こんにちは、
ACCESSにODBC接続してデータを取得を考えています。
下記のようにフローを作成したのですが、接続(2度目)で「OdbcException」が発生します。
接続(2度目)から始めると正常に接続できます。
なにかお作法があるのでしょうか
接続(1度目)→データ取得→切断→データ加工処理→接続(2度目)→データ更新→切断

@yokosawa
Could you please share the exception message ?

こんにちは、下記が発生した時のStudioの出力ウィンドウに表示された内容です。

RemoteException wrapping System.Data.Odbc.OdbcException:

Server stack trace:
場所 System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode retcode)
場所 System.Data.Odbc.OdbcConnectionHandle…ctor(OdbcConnection connection,
OdbcConnectionString constr,
OdbcEnvironmentHandle environmentHandle)
場所 System.Data.Odbc.OdbcConnectionOpen…ctor(OdbcConnection outerConnection,
OdbcConnectionString connectionOptions)
場所 System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options,
DbConnectionPoolKey poolKey,
Object poolGroupProviderInfo,
DbConnectionPool pool,
DbConnection owningObject)
場所 System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options,
DbConnectionPoolKey poolKey,
Object poolGroupProviderInfo,
DbConnectionPool pool,
DbConnection owningConnection,
DbConnectionOptions userOptions)
場所 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection,
DbConnectionPoolGroup poolGroup,
DbConnectionOptions userOptions)
場所 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection,
TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) 場所 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry,
DbConnectionOptions userOptions)
場所 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection,
DbConnectionFactory connectionFactory,
TaskCompletionSource`1 retry,
DbConnectionOptions userOptions)
場所 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection,
DbConnectionFactory connectionFactory)
場所 System.Data.Odbc.OdbcConnection.Open()
場所 UiPath.Database.DatabaseConnection.OpenConnection()
場所 UiPath.Database.DatabaseConnection…ctor(String connectionString,
String providerName)
場所 UiPath.Database.Activities.DatabaseConnect.<>c__DisplayClass12_0.b__0()
場所 System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md,
Object args,
Object server,
Object& outArgs)
場所 System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg,
IMessageSink replySink)

Exception rethrown at [0]:
場所 System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg,
Boolean bProxyCase)
場所 System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed,
MessageData& msgData)
場所 System.Func`1.EndInvoke(IAsyncResult result)
場所 UiPath.Database.Activities.DatabaseConnect.EndExecute(AsyncCodeActivityContext context,
IAsyncResult result)
場所 System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context,
IAsyncResult result)
場所 System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor,
BookmarkManager bookmarkManager)

@yokosawa

Can you try installing ms access database engine 32 or 64 bit

下記のACCESSになります
Microsoft Access 2016(16.0.4266.1001) MSO(16.0.5278.1000) 32ビット

download microsoft access database engine 2016 32 bit
install it and then re run the process

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.