MDB2

PEAR::MDB2 database abstraction layer

[ AdvancedSearch | AreaMap ]

MDB2 Microsoft SQL Server

MSSQL is the sub-package of MDB2 for connecting to Microsoft SQL Server databases.

Common Issues with MSSQL

1. PHP does not normally come with the MSSQL module installed.
   • Add the MSSQL module to PHP. Look for extension=php_mssql in php.ini
2. MDB2 does not install all of the database sub-packages by default.
   • Install the MDB2 MSSQL package. pear i pear/MDB2#mssql
3. MDB2: Connect Failed (with no further details)
   • Ensure you have network access to your SQL host.
   • Enable the TCP/IP protocol on the SQL Server (this is usually disabled by default).
   • Ensure that the SQL Server port (Default:1433) is not blocked by a firewall.

This site powered by YaWiki 0.22 beta.