Search: database-connect

RCA.Activities.Core.DatabaseDisconnect Description This activity allows you to close a connection to a database. (* for Mandatory) Properties Connection Database Connection (DatabaseConnection)* - The database connection to be closed E.g: “Server=myServerAddress;Database=myDataBase;UserId

Database Disconnect

Database

Database Disconnect

" %) ((( RCA.Activities.Core.DatabaseDisconnect == **Description** == This activity allows you to close a connection to a database. [[image:image-20220506105152-1.png]] (* for Mandatory) == **Properties** == **Connection** * **Database Connection (DatabaseConnection)*** - The database connection to be closed E.g: “Server

. When this activity ends, the connection to the database is closed. This activity returns

Configuration Connection String (String)* - The connection string used to establish a database connection. E.g

and structure your code better. Eg: Database Transaction Use Transaction (Checkbox) Output Database Connection

Database Transaction

Database

Database Transaction

" %) ((( RCA.Activities.Core.DatabaseTransaction == **Description** == This activity allows you to connect to a database and features a Sequence

Configuration** * **Connection String (String)*** - The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword

Configuration Connection String (String)* - The connection string used to establish a database connection. E.g

(DatabaseConnection)- An already opened database connection obtained from the Database Connect and Database

statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows

Database

string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId

connection obtained from the Database Connect and Database Transaction activities. This property

" %) ((( RCA.Activities.Core.ExecuteNonQuery == **Description** == This activity allows you to execute a non-query statement on a database

Connection String (String)* - The connection string used to establish a database connection. E.g: “Server

(DatabaseConnection) - An already opened database connection obtained from the Connect or Start Transaction activities

) In the body of activity Configure Connection - Set connection string, data source, data provider. Data

Database

Configuration** * **Connection String (String)*** - The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” * **Existing DbConnection (DatabaseConnection)** - An already opened database connection obtained from

)*- The connection string used to establish a database connection. E.g: “Server=myServerAddress;Database=myDataBase

database connection obtained from the Connect or Start Transaction activities. This property

on a database and returns the query result in a Datatable. (* for Mandatory) In the body of activity

Database

a database connection. E.g: “Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” * **Existing DbConnection (DatabaseConnection)** - An already opened database connection obtained from

allows you to execute a query on a database and returns the query result in a Datatable. [[image:image

=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” データプロバイダ名*：データベースへのアクセスに使用されるデータベース

.akabot.com/bin/download/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1

に使用される接続文字列です。 例：“Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword

Database

Database Transaction

;Database=myDataBase;UserId=myUsername;Password=myPassword;” 既存のDBコネクション（DatabaseConnection）：データベースを接続

）*：データベースへの接続に使用される接続文字列です。 例：“Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password

ソース、データプロバイダーを設定します。 [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png"]] * **Edit

/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image

Database

）*：データベースへの接続に使用される接続文字列です。 例：“Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password

文字列、データソース、データプロバイダーを設定します。 [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png

します。 例：True ))) **接続構成** * **接続文字列（文字列）***：データベースへの接続に使用される接続文字列です。 例：“Server=myServerAddress;Database

Database

可能です。） 接続構成 接続文字列（文字列）*：データベースへの接続に使用される接続文字列です。 例：“Server=myServerAddress;Database=myDataBase

**：接続文字列、データソース、データプロバイダーを設定します。 [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities/Database%20Connect/WebHome/image-20230419153435-1.png?rev=1.1||alt="image-20230419153435-1.png

=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;” * **既存のDBコネクション（DatabaseConnection

Database