computer:2:know

Linux / php >> connection to mssql database

 mssql connection from a linux server using odbc. 



installation for centos 7:



- yum install unixodbc freetds



- /etc/dbcinst.ini

             [FreeTDS]

              Driver=/usr/lib64/libtdsodbc.so.0

              Setup=/usr/lib64/libtdsS.so.2

              FileUsage=1

              UsageCount=1







- /etc/odbc.ini for example:

       [db01]

        Driver=FreeTDS

        Description=db01

        Trace=No

        Server=192.168.1.111

        Port=1433

        Database = Database1



- try connection using: isql -v db01 dbuser <password>



- php example:

  $conn = odbc_connect("Driver=FreeTDS;DSN=$dsn;Database=$database", $user, $pwd);

        if (!$conn){

                print '<h2> Error: Unable to connect to Database. </h2>';

        }else{

                $query = 'SELECT * from orders';

                $result = odbc_exec($conn, $query);



                while(odbc_fetch_row($result)){

                        $customer=utf8_encode(odbc_result($result, 1));

                        $title=utf8_encode(odbc_result($result, 2));

                                                $customer_name=utf8_encode(odbc_result($result, 13));

                                                $order_status1=utf8_encode(odbc_result($result, 14));

                }

                odbc_close($conn);





----------------------------------------

- see also https://zend18.zendesk.com/hc/en-us/articles/218197897-Configuring-a-Linux-Server-to-Connect-to-an-MSSQL-Database-Using-ODBC
Computer and IT knowledge - things to know

Linux / php >> connection to mssql database
