odbc-connect ( env dsn -- dbc )

Vocabulary

odbc

Inputs

env	an ODBC environment handle
dsn	a string

Outputs

dbc	an ODBC database connection handle

Word description

Connects to the database identified by the ODBC data source name (DSN). The environment handle is usually obtained by a call to odbc-init. The result is the ODBC connection handle which can be used in other ODBC calls. When finished with the connection handle odbc-disconnect must be called on it.

Examples

dbc get "DSN=snowflake; UID=sheeple; PWD=sekrit" odbc-connect

See also

odbc-init, odbc-connect, odbc-disconnect, odbc-prepare, odbc-free-statement, odbc-execute, odbc-next-row, odbc-number-of-columns, odbc-describe-column, odbc-get-field, odbc-get-row-fields, odbc-get-all-rows, odbc-query

Definition

USING: alien.c-types alien.data alien.strings io.encodings.utf8
kernel sequences ;

IN: odbc

: odbc-connect ( env dsn -- dbc )
    [ alloc-dbc-handle dup f ] [ utf8 string>alien dup length ]
    bi* 1024 temp-string 0 short <ref>
    SQL_DRIVER_NOPROMPT SQLDriverConnect
    "SQLDriverConnect" check-odbc ;