Search

'Firebird'에 해당되는 글 1건

  1. 2007.08.01 Firebird 설치및 데이타베이스 생성

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

Database 2007.08.01 08:08 Posted by 파란크리스마스
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>
  • 신고


     

    티스토리 툴바