Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - odbc_connect() - Connecting to a SQL Server through an ODBC DSN

By: FYIcenter.com

(Continued from previous topic...)

How To Connect to a SQL Server using odbc_connect()?

If you have an ODBC DSN (Data Source Name) created linking to a SQL Server, you are ready to connect to the SQL Server through the DSN with ODBC functions. There is no changes needed in the php.ini configuration file.

The tutorial script below shows you how to call odbc_connect() and odbc_close() to connect and disconnect to the SQL Server through the DSN name "FYI_SQL_SERVER":

<?php
  $con = odbc_connect('FYI_SQL_SERVER','sa','FYIcenter');
  if (!$con) {
    print("There is a problem with SQL Server connection.\n");
  } else {
    print("The SQL Server connection object is ready.\n");
    odbc_close($con); 
  }
?>

If you run this script and get this output: "The SQL Server connection object is ready", your PHP environment and ODBC connection to the SQL Server are working.

Note that 'sa' and 'FYIcenter' used in this script are system administrator login name and password. You may use any other login name and password defined on the SQL Server.

(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...