Home › Blogs › dave's blog

Mencoba Konek dari Linux ke Microsoft SQL Server ( hari ke-1 ) 09:00 WITA

Wed, 06/07/2005 - 08:00 — dave

Karena terbiasa memakai Coldfusion sebagai webserver (NT), dan mencoba koneksi apache/php (linux) ke MsSQL maka saat mencoba koneksi database kantor yang memakai MsSQL 'terpaksa' memasang tools tambahan 'unixODBC' dan 'freeTDS'

kira2 begini deh ilustrasinya

webserver (apache/php)
===========

php_script.php
|
v
UnixODBC Driver Manager
|
v
OOB Client
|
v
network
|
v

windows_server (MsSQL)
==============

OOB Server
|
v
MS Driver Manager
|
v
MS SQL Server ODBC Driver
|
v
Database

to be continue.... >> [lagi sarapan]

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Wed, 06/07/2005 - 10:58 — dave

12:02 WITA

info box linux :
RedHat 9 (2.4.20-8)
Apache/2.0.40
PHP 4.2.2
gcc 3.2.2

[ ok, sekarang download paketnya]
UnixODBC
http://www.unixodbc.org/unixODBC-2.2.11.tar.gz
FreeTDS:
http://ibiblio.org/pub/Linux/ALPHA/
freetds/stable/freetds-stable.tgz
Sybase:"sybase-common-11.9.2-1.i386.rpm"

[ Sudah beres instalasi, cek freeTDS ]
[root@unix freetds-with-unixODBC]# bin/tsql -S 169.254.194.15 -U dbadmin
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
1> quit

[ Saatnya Edit Konfigurasi php & apache ]
httpd.conf
# menambah modul baru
LoadModule php4_module libexec/libphp4.so
AddType application/x-httpd-php .php .phtml
AddType application/x-httpd-php-source .phps

to be continue .... [makan siang + sholat]

Wed, 06/07/2005 - 12:17 — cah4ngon

Lebih Sederhana dengan XML-RPC

Coba cara ini, barangkali bisa lebih sederhana, yaitu mendayagunakan XML dengan XML-RPC atau SOAP.
webserver (apache/php)
===========

php_script.php
|
v
XML - Message through RPC Client
|
v
network
|
v

webserver (apache/php) / XML-RPC Server (Delphi/VB6/Phyton/Perl/Java/VB.Net)
==============

RPC Server
|
v
MS SQL Server ODBC Driver / tergantung dengan apa bikin RPC Server-nya
|
v
Database

Ini akan efektif, jika antar mesin terutama hanya port tertentu yg diijinkan, misalnya 80 (http saja sudah cukup). Tidak ada konfigurasi rumit, saya kira. Bahasa dan platform sistem operasi apa saja, tak jadi soal. Tapi coba nanti lebih detil saya blog-kan saja :)

Wed, 06/07/2005 - 13:17 — dave

14:14 WITA

re-install old httpd webserver + php (default install with binary]
$ rpm -e httpd-2.0.40-21 mod_python-3.0.1-3 mod_perl-1.99_07-5 mod_ssl-2.0.40-21
$ rpm -e php-4.2.2-17
coba compile saja (source)
[download source apache *httpd 2.0.54]
http://www.ibiblio.org/pub/mirrors/apache/httpd/httpd-2.0.54.tar.gz
[download source php 4.3.11]
http://id2.php.net/distributions/php-4.3.11.tar.gz

Wed, 06/07/2005 - 14:32 — dave

15:33 WITA

[root@unix httpd-2.0.54]
./configure --quiet \
--prefix=/usr/local/apache \
--enable-shared=max \
--enable-module=so
[root@unix php-4.3.11]
./configure --quiet \
--with-apxs2=/usr/local/apache/bin/apxs \
--disable-debug \
--enable-ftp \
--enable-inline-optimization \
--enable-magic-quotes \
--enable-mbstring \
--enable-mm=shared \
--enable-safe-mode \
--enable-track-vars \
--enable-trans-sid \
--enable-wddx=shared \
--enable-xml \
--with-db \
--with-dom \
--with-gd \
--with-gettext \
--with-mysql \
--with-regex=system \
--with-sybase=/usr/local/freetds-with-unixODBC \
--with-mssql=/usr/local/freetds-with-unixODBC \
--with-xml

Wed, 06/07/2005 - 14:56 — dave

15:46 WITA

[download modul lainnya] :)
mod_ssl
http://www.modssl.org/source/mod_ssl-2.8.22-1.3.33.tar.gz
openssl
http://www.openssl.org/source/openssl-0.9.8.tar.gz
rsaref2
http://www.funet.fi/pub/crypt/cryptography/asymmetric/rsa/rsaref2.tar.gz
libxml2
ftp://ftp.gnome.org/mirror/gnome.org/sources/libxml2/2.6/libxml2-2.6.19.tar.gz

sholat ashar...
(`)_
//\
\V_

Wed, 06/07/2005 - 15:37 — dave

16:38 WITA

persiapan Upgrade SP4 windows 2000 Professional for client
Jaka Sembung Naik Ojek = Ngk Nyambung Jack !
Namanya juga bL0g

(*)_
//\
V_/_
dave g0 to h0m3
16:41 WITA

Sat, 09/07/2005 - 11:36 — dave

12:31 WITA (hari ke-2)

Baru sekarang bisa melanjutkan instalasi yg hari ke-1, Alhamdulillah mesin linux udah bisa konekesi ke M$SQL dan ada tambahan setting buat perl, jadi rencananya sich (InsyaAllah) mau posting sekalian di artikel mengenai "LiNUX (APACHE,PHP,PERL)+ M$SQL SERVER" yaa mungkin sudah ada artikel yg berbahasa indonesia yg lengkap (walaupun) HOW TO yang aku buat ngk lengkap amat :)

dave g0 t0 DAUROH (UNTAG-samarinda)
12:39 WITA