728x90
반응형
flamerobin-0.9.2-1-setup.exe
다운로드
Firebird-2.5.5.26952_0_x64.exe
다운로드
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>
* from http://bluexmas.tistory.com/2
'DB 관련' 카테고리의 다른 글
| [MSSql] hierarchyid 데이터형을 이용한 트리구조 생성 (0) | 2024.12.27 |
|---|---|
| [MsSql] DB의 모든 테이블의 모든 데이터 삭제하는 방법 (0) | 2024.12.27 |
| [MsSql] 테이블의 필드값을 행에서 열로 표시한다.(PIVOT 함수 사용) (0) | 2024.12.27 |
| [MsSql] hierarchyid 를 사용한 계층구조 검색 (0) | 2024.12.27 |
| [Firebird] 계층적 데이터 쿼리 (0) | 2024.12.27 |