Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Requirements for Connecting PHP to MS SQL Server

By: FYIcenter.com

(Continued from previous topic...)

What Do You Need to Connect PHP to SQL Server?

If you want to access MS SQL Server in your PHP script, you need to make sure that:

1. MSSQL API module (extension) is installed and turned on in your PHP engine. If you installed the Windows binary version of PHP 5.2.3, MSSQL API module is included but not turned yet. See the next tutorial on turning on MSSQL API module.

If you are getting errors like: "Fatal error: Call to undefined function mssql_connect()", you know that MSSQL API module is not turned on correctly. See the next tutorial on turning on the MSSQL API module.

2. MS SQL Client Tools to be installed on the system where PHP is installed. The PHP manual also suggested an alternative, which is to get a copy of the SQL Server Client Libarary DLL, ntwdblib.dll. Again Windows binary version of PHP 5.2.3 contains a copy of ntwdblib.dll.

If you are getting errors like: "Unable to load dynamic library './ext\php_mssql.dll' - The specified module could not be found", you know that the DLL, ntwdblib.dll, is not installed correctly. See the next tutorial on installing ntwdblib.dll.

(Continued on next topic...)

  1. How To Download and Install PHP on Windows?
  2. How To Check Your PHP Installation?
  3. What Do You Need to Connect PHP to SQL Server?
  4. How to Turn on the MSSQL API Module?
  5. What Is Wrong with SQL Server Client Libarary DLL, ntwdblib.dll?
  6. What Happens If ntwdblib.dll Is Missing on Your Machine?
  7. Where to Find ntwdblib.dll Version 2000.80.194.0?
  8. How To Connect with Different Port Numbers?
  9. What Are Commonly Used MSSQL Functions in PHP?
  10. How To Disconnect from a SQL Server using mssql_close()?
  11. How To Select an Exiting Database using mssql_select_db()?
  12. How To Execute a SQL Statement using mssql_query()?
  13. How To Retrieve Error Messages using mssql_get_last_message()?
  14. How To Turn Off Warning Messages during PHP Execution?
  15. How To Receive Returning Result from a Query?
  16. How To Loop through Result Set Objects using mssql_fetch_array()?
  17. How To Retrieve Field Values using mssql_result()?
  18. How To List All Field Names in the Result Set using mssql_field_name()?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...