note 117223 added to mssql.installation
| From: | sbonder at outlook dot com | Date: | Tue, 05 May 2015 14:01:24 +0000 |
| Subject: | note 117223 added to mssql.installation | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202444@lists.php.net to get a copy of this message | ||
This is how I got it to work:
> Install the necessary packages for FreeTDS:
sudo apt-get -y install freetds-bin tdsodbc unixodbc
> Configure FreeTD
nano /etc/freetds/freetds.conf
> Create a server
[sqlserver]
host = <server_name>
port = 1433
tds version = 8.0
> You can now test whether you can connect to your MSSQL Server as follows - using the tsql
> command line tool:
tsql -S <createdsevername> -U <username> -P <password> -D
<chosen_database>
> You should get a message that looks similar to this:
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
Default database being set to <chosen_database>
1> quit
> Install a php extention:
apt-get install php5-sybase
> Check if mssql in available in you phpinfo
----
Server IP: 72.52.91.14
Probable Submitter: 105.210.51.53
----
Manual Page -- http://php.net/manual/en/mssql.installation.php
Edit -- https://master.php.net/note/edit/117223
Del: integrated -- https://master.php.net/note/delete/117223/integrated
Del: useless -- https://master.php.net/note/delete/117223/useless
Del: bad code -- https://master.php.net/note/delete/117223/bad+code
Del: spam -- https://master.php.net/note/delete/117223/spam
Del: non-english -- https://master.php.net/note/delete/117223/non-english
Del: in docs -- https://master.php.net/note/delete/117223/in+docs
Del: other reasons-- https://master.php.net/note/delete/117223
Reject -- https://master.php.net/note/reject/117223
Search -- https://master.php.net/manage/user-notes.php