Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Requirements to Use ODBC Connections in PHP

By: FYIcenter.com

(Continued from previous topic...)

What Are the Requirements to Use ODBC Connections in PHP Scripts?

If you are planning to use ODBC connections to access SQL Server databases in PHP scripts, you need to check the following requirements:

  • The PHP engine must support ODBC functions. If you install PHP 5.2.2 from The PHP Group, the ODBC functions are already included in the default installation.
  • The SQL Server must have TCP/IP protocol enabled for a specific port.
  • The SQL Server Browser Service must be running on the SQL server machine.
  • An ODBC DSN must be created on machine where you are running PHP scripts.
  • The ODBC DSN connection must be tested to make sure it is working.

You need to following other tutorials provided by FYIcenter.com to install PHP engine, install SQL Server, configure TCP/IP protocol, start SQL Server Browser Service, create and test ODBC DSN connections.

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


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: