`odbc_close()` does not report success and some drivers (namely Microsoft Access) don't seem to close connections at first attempt. This is normally not an issue, unless you need to establish many connections within the script lifetime.
You can use the fact that resource type changes (e.g. from "odbc link" to "Unknown") as a trick to figure out whether connection was successfully closed (and eventually retry):
<?php
$type = get_resource_type($conn);
$wait_until = time() + 3;
do {
odbc_close($conexion_odbc);
} while (get_resource_type($conn)===$type && time()<$wait_until);
odbc_close
(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_close — Fecha uma conexão ODBC
Descrição
odbc_close
( resource
$connection_id
) : voidFecha a conexão com o servidor de banco de dados.
Parâmetros
-
connection_id -
O identificador de conexão.
Valor Retornado
Não há valor retornado.
Notas
Nota:
Esta função irá falhar se houverem transações abertas nesta conexão. A conexão permanecerá aberta neste caso.
add a note
User Contributed Notes 1 note
alvaro at demogracia dot com ¶
6 years ago
