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>