Download the PHP package silverstripe/mssql without Composer

On this page you can find all versions of the php package silverstripe/mssql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package mssql

SQL Server Database Module

Allows SilverStripe to use SQL Server databases.

Build status

Maintainer Contact

Requirements

mssql PHP api is no longer supported as of 2.0

*nix

Linux support is only available via the PDO extension. This requires:

Windows

On windows you can either connect via PDO or sqlsrv. Both options require the SQL Server Driver for PHP. "sqlsrv" 3.0+

Note: SQL Server Express can also be used which is provided free by Microsoft. However, it has limitations such as 10GB maximum database storage.

Installation

These steps will install the latest SilverStripe stable, along with this module using Composer:

Troubleshooting

Q: SQL Server resides on a remote host (a different machine) and I can't connect to it from mine.

A: Please ensure you have enabled TCP access using SQL Server Configuration Manager and opened firewall ports.

Q: I just installed SQL Server, but it says that it cannot connect

A: Sometimes SQL Server will be installed as a non-default instance name, e.g. "SQLExpress" instead of "MSSQLSERVER" (the default.) If this is the case, you'll need to declare the instance name when setting the server in your PHP database configuration. For example: (local)\SQLExpress. The first part before the slash indicates the server host, or IP address. In this case, (local) indicates localhost, which is the same server PHP is running on. The second part is the SQL Server instance name to connect to.

Q: I'm getting unicode SQL Server errors connecting to SQL Server database (e.g. Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier)

A: If you are using FreeTDS make sure you're using TDS version 8.0 in freetds.conf. If on Windows, ensure you use the SQL Server Driver for PHP and NOT the mssql drivers provided by PHP.

Q: Using FreeTDS I can't connect to my SQL Server database. An error in PHP says the server doesn't exist

A: Make sure you've got an entry in /etc/freetds/freetds.conf that points to your server. For example:

[myserver]
    host = myserver.mydomain.com
    port = 1433
    tds version = 8.0

Then you can use "myserver" (the bit in square brackets above) as the server name when connecting to the database. Note that if you're running Macports, the file is located in /opt/local/etc/freetds/freetds.conf.

Alternatively, if you don't want to keep adding more entries to the freetds.conf to nominate more SQL Server locations, you can instead use the full the host/ip and port combination, such as "myserver:1433" (1433 being the default SQL Server port.) and ensure the "tds version = 8.0" is set globally in the freetds.conf file.

Note: Use tabs not spaces when editing freetds.conf, otherwise it will not load the configuration you have specified!

Note: Certain distributions of Linux use SELinux which could block access to your SQL Server database. A rule may need to be added to allow this traffic through.

All versions of mssql with dependencies

PHP Build Version
Package Version
Requires silverstripe/framework Version ^4
silverstripe/vendor-plugin Version ^1.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package silverstripe/mssql contains the following files

Loading the files please wait ....