Unlike a desktop database (relatively real database, it should be called a data sheet), the interbase database exists only one "big file" with .GDB, this file will all the data sheets, index, Store procedures, views, triggers, exceptions, etc. "packaging" together. Such a database is greatly simplified for the maintenance and backup of the data.
To create a database, first you have to install Interbase first, the following discussion is discussed in Interbase 6, without Interbase 6, please download an interbase 6 in the software download bar of this site. The default installation path of Interbase 6 is "C: / Program Files / Borland / InterBase".
Open "Start" -> Programs -> "Interbase" -> "ibconsole".
You will see the main interface of IBCONSOLE:
The steps are as follows:
1: Database server login.
A: Double-click Interbase Servers or select Interbase Servers to select the REGISTER menu to open the Register Server and Connect window.
B: If it is logged in to the local, select Local Server within the Server Information page. Enter your username and the correct password in the Login Information page. Interbase's default user name is sysdba, the password is: MasterKey (pay attention to password sensitive).
C: If you are logging in to the remote server, select Romote Server in the Server Information page, different from Local Server, Server Name, NetWord Protocol, with Alias Name, and require users to fill in. (, Such as: Server Name is set to 3Hsoft.Network Protocol Select TCP / IP, Alias Name We are set to test.) The operation within the Login Information page is above B.
2: Create a database A: After the above steps are successfully logged in to the server, open the Local Server of the left window in the ibconsole (assuming that we are logged in by the local server).
B: Select the Databases option, right-click, appear on the Register and Create Database, because we are here to create a database, so we select the Create Database menu to pop up the Create Database window.
C: Fill in the alias of the database in Alias in the Create Database window. Such as: Test
D: Fill in the data name you want to create within the filename below the file (s) page, this database name must contain the correct path. Such as: (E: /3HSOT /APPLICATION/book/test/extradata/test.gdb.)
E: If you create a database on the network, you have to add the name of the server. Such as: 3Hsot: g: /application/book/test/test.gdb. Different communication protocols are slightly different. A: TCP: Server Name: Path
B: NetBeui: // Server Name / Path C: SPX: Server Name @Path
【Note】
The path here refers to the absolute path of the server, which is not the mapping path of the server through the local PC. Many beginners are connected in parallel with Interbase's servers (also determined the communication protocol). F: Options for Option A: Select Page Size Size, generally select 4096. The size of the Page Size sometimes affects the access speed of the database.
B: Set the Default Character Set, this item sets the default language character, which is usually set to None.
C: Set SQL DIALECT. If you want to create a database that needs to be compatible with the old version of Interbase, set it to 1. Instead, set it to 3.
G: Click the "OK" button to get it.
H: Of course, you can also use the command line to create a database, but this requires a more proficiency of the SQL statement, if you want to create the same database, open the Interactive SQL window, write the following name and execute: create Database ' E: /3HSOT /APPLICATION/book/test/extradata/test.gdb 'page_size 4096; In the following chapter, I will discuss some of the use and techniques of Create Database nature.
3: Go back to the IBCONSOLE main window, you can see the database TEST you just created, but the content is empty, because you have not created a table, view, storage process, etc., this is just one head, I hope Is a good head.
