Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - odbc_data_source() - Listing All DSN Entries

By: FYIcenter.com

(Continued from previous topic...)

How To List All DSN Entries on Your Local Machine using odbc_data_source()?

If you are interested to know what DSN entries are available on your local machine, you can use odbc_data_source($con, SQL_FETCH_FIRST) and odbc_data_source($con, SQL_FETCH_NEXT) in a loop to list all DSN entries defined on your local machine. The tutorial script below shows a good example:

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');
  if (!$con) {
    print("There is a problem with the connection.\n");
  } else {
    print("The ODBC connection object is ready.\n");
    $list = odbc_data_source($con, SQL_FETCH_FIRST);
    while ($list) {
       foreach ($list as $key => $value) {
          print($key . " = " . $value . "\n");
       }
       $list = odbc_data_source($con, SQL_FETCH_NEXT);
    }
    odbc_close($con); 
  }
?>

If you run this script, you will get something like this:

The ODBC connection object is ready.
server = MS Access Database
description = Microsoft Access Driver (*.mdb)
server = dBASE Files
description = Microsoft dBase Driver (*.dbf)
server = Excel Files
description = Microsoft Excel Driver (*.xls)
server = FYI_SQL_SERVER
description = SQL Server

Warning: odbc_data_source(): SQL error: [Microsoft]
[ODBC SQL Server Driver][SQLServer]Changed database context
to 'FyiCenterData'., SQL state 01000 in SQLDataSources in 
C:\test\fyi_center.php on line 12

The error message seems to be very strange. But the result is correct.

(Continued on next topic...)

  1. What Are the Requirements to Use ODBC Connections in PHP Scripts?
  2. What Are Commonly Used ODBC Functions in PHP?
  3. How To Test ODBC DSN Connection Settings?
  4. How To Connect to a SQL Server using odbc_connect()?
  5. How To List All DSN Entries on Your Local Machine using odbc_data_source()?
  6. How To Execute a SQL Statement using odbc_exec()?
  7. How To Retrieve Error Messages using odbc_errormsg()?
  8. How To Turn Off Warning Messages during PHP Execution?
  9. How To Receive Returning Result from a Query?
  10. How To Loop through Result Set Objects using odbc_fetch_row()?
  11. How To Retrieve Field Values using odbc_result()?
  12. How To List All Tables in the Database using odbc_tables()?
  13. How To List All Columns in a Table using odbc_columns()?
  14. How To Create Prepared Statements using odbc_prepare()?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...