https://community.blueprism.com/t5/Product-Forum/Database-Connections/m-p/82244#M33706 <P>Hypothetically,<BR />Is it possible 2 have more than one connection open in a process at a time.<BR /><BR />I'm foreseeing a time where I may have to update 2 separate databases on different hosts<BR /><BR />Ed</P><BR /><BR />------------------------------<BR />Edmund Horrocks<BR />------------------------------<BR /> Fri, 05 May 2023 12:51:00 GMT EdmundHorrocks 2023-05-05T12:51:00Z https://community.blueprism.com/t5/Product-Forum/Database-Connections/m-p/82244#M33706 <P>Hypothetically,<BR />Is it possible 2 have more than one connection open in a process at a time.<BR /><BR />I'm foreseeing a time where I may have to update 2 separate databases on different hosts<BR /><BR />Ed</P><BR /><BR />------------------------------<BR />Edmund Horrocks<BR />------------------------------<BR /> Fri, 05 May 2023 12:51:00 GMT https://community.blueprism.com/t5/Product-Forum/Database-Connections/m-p/82244#M33706 EdmundHorrocks 2023-05-05T12:51:00Z https://community.blueprism.com/t5/Product-Forum/Database-Connections/m-p/82245#M33707 <P>Theoretically, a process can connect to more than one database.<BR />Updating individual databases is processed as a separate transaction.<BR />As a result, consistency may not always be guaranteed.<BR />Fortunately, we may be able to implement a way to minimize this situation using the Blue Prism Work Queue.</P><BR /><BR />------------------------------<BR />Bohyon Hwang<BR />Director<BR />블루프리즘<BR />Seoul<BR />+82262033950<BR />------------------------------<BR /> Mon, 08 May 2023 06:21:00 GMT https://community.blueprism.com/t5/Product-Forum/Database-Connections/m-p/82245#M33707 BohyonHwang 2023-05-08T06:21:00Z