작업을 하다 보니까.. 필요하더군요.. 이번주 수요일까지 다 마쳐야 되는데.. 엉엉..
============
Connect to mssql2k from linux by freetds with DBD-Sybase for perl programming
(but it can be used in other programming environment as I know)
written by yuletide <yctae at hotmail.com>
installation
^^^^^^^^^^^^
[requirement]
wowlinux6.2update
ms window 2000 server
ms sql 2000 -eval120- from microsoft
freetds-0.51.tgz from freetds.org
DBD-Sybase-0.91.tar.gz from www.perl.com/CPAN [ms sql 200 eval120 install]
컴퓨터 관리
add user, sa/qwerASDF
sqleval.exe
cd c:sqleval
autorun
데이타베이스 설치
로컬 호스트
새 SQL Server인스턴스를 만들거나 클라이언트 도구 설치
이름: nano
회사: neo
서버와 클라이언트 도구
기본값
표준
각 서비스에 대해 동일한 계정 사용, SQL Server 서비스 자동 시작
로컬 시스템 계정사용
혼합모드(Window인증과 SQL Server 인증)
완료
[freetds-0.51 install]
tar xvfzp freetds-0.51.tgz
cd freetds-0.51
./configure --with-tdsver=7.0 --enable-msdblib
gmake
gmake install
vi ~/.bash_profile
---
SYBASE=/usr/local/freetds
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib
---
source ~/.bash_profile
vi PWD
---
UID=sa
PWD=qwerASDF
SRV=nano213
DB=pubs
---
vi /usr/local/freetds/interface
---
nano213
query tcp tds7.0 10.10.10.213 1433
master tcp tds7.0 10.10.10.213 1433
---
gmake check
[DBD-Sybase-0.91 install]
tar DBD-Sybase-0.91.tar.gz
cd DBD-Sybase-0.91
vi CONFIG
---
SYBASE=/usr/local/freetds
EXTRA_LIBS=-linsck
DBI_INCLUDE=/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/
---
p.s. - "perl -MCPAN -e shell" then "install DBI"
perl Makefile.PL
cp ../freetds-0.51/PWD .
cd t
mv fail.t fail.t.orig
cd ..
make test
make install
reference
^^^^^^^^^
INSTALL/freetds-0.51
README/freetds-0.51
FreeTDS Users Guide from freetds.org
http://www.hklc.com/infocenter/Linux_x_Install_x_Perl_MSSQL.html MSSQL Perl and FreeTDS -27th September 2000-
http://database.sarang.net/database/freetds/freetds.html FreeTDS 를 이용한 DBMS 서버와 리눅스의 연결 -김
철환- MicroSoft SQL Server 2000 Programming StepbyStep -Riordan. 박민호 편역-
Perl for System Administration -Blank-Edelman O'Reilly-
--
to be or not to be that is the Q