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.

⇒ odbc_data_source() - Listing All DSN Entries

⇐ Testing ODBC DSN Connection Settings

⇑ SQL Server FAQs - PHP ODBC Functions - Connection and Query Execution

⇑⇑ SQL Server Connection Tutorials