Request nya om danang – ponorogo agar dibuatkan tuts nya, biar gak lupa katanya…<\/p>\n
tuts ini dimaksudkan agar php5 + apache2 yang terinstall pada os debian dapat mengakses database pada server windows yang menjalankan mssql2000 (umumnya digunakan oleh server simda).<\/p>\n
1. persiapan : os debian7 fresh install sdh bisa menjalankan ssh dan apt-get update.
\n2. apt-get install php5-sybase php5-odbc freetds-common
\n3. edit file \/etc\/freetds\/freetds.conf agar menjadi :<\/p>\n
[sql2000]
\nhost = 192.168.100.100
\nport = 1433
\ntds version = 7.0<\/p>\n
4. skrip berikut dapat digunakan untuk mengecek apakah konfigurasi freetds dan koneksi ke server db sql2000 sudah berjalan dengan baik, buatlah file \/var\/www\/testdb.php :<\/p>\n
——–awal file———-
\n# <?php
\n# $server = ‘sql2000’;
\n# $username = ‘sa’;
\n# $password = ‘passwordnya_sa’;
\n# $database = ‘nama_database’;
\n# $connection = mssql_connect($server, $username, $password);
\n#
\n# if($connection != FALSE)
\n# {
\n# echo “Connected to the database server OK
\n“;
\n# }
\n# else
\n# {
\n# die(“Couldn’t connect”);
\n# }
\n#
\n# if(mssql_select_db($database, $connection))
\n# {
\n# echo “Selected $database ok
\n“;
\n# }
\n# else
\n# {
\n# die(‘Failed to select DB’);
\n# }
\n#
\n# $query_result = mssql_query(‘SELECT @@VERSION’);
\n# $row = mssql_fetch_array($query_result);
\n#
\n# if($row != FALSE)
\n# {
\n# echo “Version is {$row[0]}
\n“;
\n#}
\n# mssql_free_result($query_result);
\n# mssql_close($connection);
\n#
\n# ?>
\n—–akhir file————<\/p>\n
5. ujicoba dengan mengakses file testdb.php melalui browser.<\/p>\n
selamat mencoba..DWYOR!<\/p>\n
(sumber : https:\/\/blog.thesysadmins.co.uk\/ubuntu-server-connect-to-mssql-via-php.html)<\/p>\n","protected":false},"excerpt":{"rendered":"
Request nya om danang – ponorogo agar dibuatkan tuts nya, biar gak lupa katanya… tuts ini dimaksudkan agar php5 + apache2 yang terinstall pada os debian dapat mengakses database pada server windows yang menjalankan mssql2000 (umumnya digunakan oleh server simda). 1. persiapan : os debian7 fresh install sdh bisa menjalankan ssh dan apt-get update. 2. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-320","post","type-post","status-publish","format-standard","hentry","category-linux-server"],"_links":{"self":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/320","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=320"}],"version-history":[{"count":5,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":325,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/320\/revisions\/325"}],"wp:attachment":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}