array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'de', ), 'this' => array ( 0 => 'function.odbc-data-source.php', 1 => 'odbc_data_source', ), 'up' => array ( 0 => 'ref.uodbc.php', 1 => 'ODBC Funktionen', ), 'prev' => array ( 0 => 'function.odbc-cursor.php', 1 => 'odbc_cursor', ), 'next' => array ( 0 => 'function.odbc-do.php', 1 => 'odbc_do', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/uodbc/functions/odbc-data-source.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(PHP 4 >= 4.3.0, PHP 5, PHP 7, PHP 8)
odbc_data_source — Returns information about available DSNs
This function will return the list of available DSN (after calling it several times).
odbc
Eine ODBC-Verbindungsressource, siehe odbc_connect() für Details.
fetch_type
The fetch_type
can be one of two constant types:
SQL_FETCH_FIRST
, SQL_FETCH_NEXT
.
Use SQL_FETCH_FIRST
the first time this function is
called, thereafter use the SQL_FETCH_NEXT
.
Returns false
on error, an Array upon success, and null
after fetching
the last available DSN.
Beispiel #1 List available DSNs
<?php
$conn = odbc_connect('dsn', 'user', 'pass');
$dsn_info = odbc_data_source($conn, SQL_FETCH_FIRST);
while ($dsn_info) {
print_r($dsn_info);
$dsn_info = odbc_data_source($conn, SQL_FETCH_NEXT);
}
?>
Das oben gezeigte Beispiel erzeugt eine ähnliche Ausgabe wie:
Array ( [server] => dsn [description] => ODBC Driver 17 for SQL Server ) Array ( [server] => other_dsn [description] => Microsoft Access Driver (*.mdb, *.accdb) )