티스토리 뷰

Database

Firebird 설치및 데이타베이스 생성

파란크리스마스 2007. 8. 1. 08:08
728x90
Install
	
1. Registry 등록
(HKLM\Software\Firebird Project\Firebird Server\Instances)

C:\Firebird\bin>instreg.exe install
Firebird has been successfully installed in the registry.

2. NT 서비스 등록

C:\Firebird\bin>instsvc.exe install
Service "Firebird Server - DefaultInstance" successfully created.

※ CS(Classic Server) 인 경우

C:\Firebird\bin>instsvc.exe install -classic
Service "Firebird Server - DefaultInstance" successfully created.

3. Client 라이브러리 설치

  • fbclient.dll 인스톨 C:\Firebird\bin>instclient.exe i f FBCLIENT.DLL has been installed to the System directory.
  • gds32.dll 인스톨 C:\Firebird\bin>instclient i g GDS32.DLL has been installed to the System directory. Uninstallation 1. NT 서비스 종료 C:\Firebird\bin>instsvc.exe stop Service "Firebird Server - DefaultInstance" successfully stopped. 2. NT 서비스 제거 C:\Firebird\bin>instsvc.exe remove Service "Firebird Server - DefaultInstance" successfully deleted. 3. Registry 정보 제거 C:\Firebird\bin>instreg.exe remove Firebird has been successfully deleted from the registry. 4. Client 라이브러리 제거
  • fbclient.dll 제거 C:\Firebird\bin>instclient r f The FBCLIENT.DLL has been removed from the System directory.
  • gds32.dll 제거 C:\Firebird\bin>instclient r g The GDS32.DLL has been removed from the System directory. 접속 C:\Firebird\bin>fbserver.exe -a C:\Firebird\bin>gsec -user sysdba -password masterkey GSEC> Changing the SYSDBA password C:\Firebird\bin>gsec -user sysdba -pass masterkey -mo sysdba -pw asdf1234 사용자 생성 GSEC> add testuser -pw testpw 사용자 조회 GSEC> di user name uid gid full name ------------------------------------------------------------------------------------------ SYSDBA 0 0 Sql Server Administrator TESTUSER 0 0 GSEC> quit 데이타베이스 생성 C:\Firebird>bin\isql Use CONNECT or CREATE DATABASE to specify a database SQL> create database 'C:\Firebird\data\test.fdb' user 'TESTUSER' password 'testpw' page_size 8192 default character set UNICODE_FSS; 데이타베이스 접속 C:\Firebird>bin\isql Use CONNECT or CREATE DATABASE to specify a database SQL> connect 'C:\Firebird\data\test.fdb' user 'TESTUSER' password 'testpw'; Database: 'C:\Firebird\data\test.fdb', User: TESTUSER SQL>
  • 댓글
    300x250
    공지사항
    최근에 올라온 글
    최근에 달린 댓글
    Total
    Today
    Yesterday
    «   2024/03   »
    1 2
    3 4 5 6 7 8 9
    10 11 12 13 14 15 16
    17 18 19 20 21 22 23
    24 25 26 27 28 29 30
    31
    글 보관함