ODBC Library/en: Unterschied zwischen den Versionen
Cg (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „== Introduction == The ODBC Library contains action blocks to access databases via the ODBC interface, which is a common database access layer providing a comm…“) |
Cg (Diskussion | Beiträge) |
||
| Zeile 12: | Zeile 12: | ||
== Connecting / Disconnecting == |
== Connecting / Disconnecting == |
||
==== [ODBC] Connect ==== |
|||
-- to be documented -- |
|||
Establishes a connection to a database. You have to provide the logical name of the database, and possibly a user/password combination. The logical name is typically specified in your operating systems ODBC configuration dialog. |
|||
Upon success, a session handle is written to the output pin. This is needed to further talk to the |
|||
database, and either stored in a variable, or passed along a pin-connection to one of the query actions below. |
|||
==== [ODBC] Disconnect ==== |
|||
Closes a database connection. Takes a connection handle as generated by "[ODBC] Connect" as input. |
|||
== SQL Queries == |
== SQL Queries == |
||
Version vom 17. Oktober 2019, 12:10 Uhr
Inhaltsverzeichnis
Introduction[Bearbeiten]
The ODBC Library contains action blocks to access databases via the ODBC interface, which is a common database access layer providing a common API to different databases. Almost every relational database provides an ODBC driver and is thus accessable.
Make sure that ODBC has been installed and configured on your machine, when using ODBC actions (on most machines, this is already installed, and you have to define the mapping from logical database names to driver type, host, username etc. in a setup dialog).
Connecting / Disconnecting[Bearbeiten]
[ODBC] Connect[Bearbeiten]
Establishes a connection to a database. You have to provide the logical name of the database, and possibly a user/password combination. The logical name is typically specified in your operating systems ODBC configuration dialog. Upon success, a session handle is written to the output pin. This is needed to further talk to the database, and either stored in a variable, or passed along a pin-connection to one of the query actions below.
[ODBC] Disconnect[Bearbeiten]
Closes a database connection. Takes a connection handle as generated by "[ODBC] Connect" as input.
SQL Queries[Bearbeiten]
-- to be documented --
