PHP 7.1.18 Released

odbc_close

(PHP 4, PHP 5, PHP 7)

odbc_closeCerrar una conexión ODBC

Descripción

void odbc_close ( resource $connection_id )

Cierra una conexión a un servidor de bases de datos.

Parámetros

connection_id

El conector identificador ODBC, ver odbc_connect() para más información.

Valores devueltos

No devuelve ningún valor.

Notas

Nota:

Esta función fallará si hay transaccines abiertas sobre una conexión. En este caso la conexión permanecerá abierta.

add a note add a note

User Contributed Notes 2 notes

up
0
alvaro at demogracia dot com
1 month ago
`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);
up
-23
mallsop at ind dot net
18 years ago
On microsoft servers, use the odbc_free_result command.
To Top