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