odbx_unbind(3)

NAME

odbx_unbind - Disconnects from the database

SYNOPSIS

FC#include <opendbx/api.h>F[0]

FCint odbx_unbindF[0] FC(odbx_t* handle);F[0]

DESCRIPTION

Releases the binding of the connection to the database and user associated by FCodbx_bindF[0]() to the supplied connection object. This is useful for switching to a different database or binding to the database with different credentials. It is also possible to set new connection related options before rebinding to the database server. If an open transaction exists while this function is executed in the firebird backend, it will be committed to the database and closed. The behavior of the other backends for open transactions may vary.

It's necessary to process all result sets returned by the database server before using this function. Otherwise, it might return an error depending on the native database client library and the backend module. This function must be invoked before calling FCodbx_finishF[0]() to avoid memory leaks and connections left open which may block necessary resources later on.

The FChandleF[0] parameter has to be the connection object created and returned by FCodbx_initF[0](). It becomes invalid after it was supplied to FCodbx_finishF[0]() and FCodbx_unbindF[0]() will return an error in this case.

RETURN VALUE

FCodbx_unbindF[0]() returns FCODBX_ERR_SUCCESSF[0], or an error code whose value is less than zero if one of the operations couldn't be completed successfully. Possible error codes are listed in the error section and they can be feed to FCodbx_errorF[0]() and FCodbx_error_typeF[0]() to get further details.

ERRORS

-FCODBX_ERR_PARAMF[0]: FChandleF[0] is NULL or the supplied connection object is invalid