EMS logo

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Setting database general options


This window allows you to set the basic parameteres of the database, such as file path, database login, page size, SQL dialect, etc.

Database file

A new database file specification, including full name of database file. E.g. if you use protocol TCP/IP to access server "myserver" and you want to create database "mydatabase" in folder "bases" on disc C, you should fill this edit field like is shown: c:\bases\mydatabase.gdb

User Name
Checks the user name against valid user name and password combinations in the security database on the server where the database will reside.

Password
Checks the password against valid user name and password combinations in the security database on the server where the database will reside.

Page Size
Size, in bytes, for database pages. Can be 1024 , 2048, 4096 (default), or 8192.

Charset
Sets default character set for a database charset; if omitted, character set defaults to NONE.   

SQL Dialect
Declares the SQL Dialect for database access.

SQL Dialect
Used for
1  
InterBase 5.5 and earlier compatibility
3  
InterBase 6.0; allows you to use delimited identifiers, exact numerics, and DATE, TIME, and TIMESTAMP datatypes


chbox Single Database File
If you want to store your new database in several files, uncheck this option. By default this option is checked that value means that the database is stored in one file only.


See also:
Create Database Wizard



hs1370_general options

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

MySQL Gold Certified Partner
Microsoft Gold Certified Partner
Oracle Certified Partner
Borland Technology Partner
CodeGear - Where Developers Matter