602SQL Documentation Index  

Create a new local server

You can set information needed for the registration of a local database in this dialog. If this database does not exist, it will be created. This dialog can be displayed from the pop-up menu of the root item of the object tree in the Control Panel.

Server name: Set the name you will use to connect to the server (the server will be displayed in the Control panel under this name). The name must be different from the other registered server names and may contain letters, digits and "_". The maximum length of the name is 31 characters.

Database file directory: Choose the database file directory. You can get more information about database files on the page Overview and locations of database files. If a database file already exists in the specified directory, it will be used and a new database file will not be created.

System charset: Set the system language and charset that will be used for internal sorts, comparisons, case changes and similar identifier operations on the server. This does not have any connection to the data language selection for tables. More details can be found on the page Database system language.

Allow tables bigger than 4GB: Check if expect the size of single database tables bigger than 4 GB (only fixed-length data, not data of variable-length as BLOBs or CLOBs)

Port: Choose the basic port number the 602SQL Server will be listening. Details about ports can be found on the page Ports and firewalls when using TCP/IP communication.

Administrator Account

For the Windows version of the SQL server, data specified here are written into Windows Registry. If the permissions are sufficient, the registration is written to the HKEY_LOCAL_MACHINE branch, otherwise it is done into the HKEY_CURRENT_USER branch and the other users of this computer will not see the registration.