Identifying a New Server
New Local or Remote Servers can be identified on Loging Screen.
First of all, "New Server" must be selected from the bar standing next to "Server Settings" button on the screen.
- Identifying a Local Server:
Click "New Server" as shown above.
- SQL Server Name: Enter a name for new Server.
- SQL Engine: Select the SQL Engine type. Supported engines are; Postgre SQL, My SQL, Microsoft SQL, Oracle, ODBC.
- IP/ Server: If the database of the performed tests will be kept only on this computer, enter "Localhost". Entering Server's IP to this cell, will allow the other users to reach this computer's database.
- Port Number: Enter the port number used to connect to the server.
- MAC Adress: The MAC Adress of the computer which is operated on.
- Database Prefix: This is used to separate different databases kept in the same server.
- Company/Database Code: Defines the related company or database.
- SQL User: Username created automatically to access database.
- SQL Password: Define a password for the user.
PostgreSQL:
MySQL:
MicrosoftSQL(MsSQL):
Oracle:
ODBC:
- Click the "Connect" button for connecting the server.
2.Connecting to a Taxi Server:
Owning a dedicated server brings extra cost and extra labour. Therefore some companies hire SQL Servers from hosting companies to lower costs.
To connect to the Taxi Server:
- With the interface program (CPanel or etc.) provided by Hosting Company, create 2 databases like "company name_" (adak_) and "company name_management" (adak_management) at the server inside the Data Center.
- Define a fully authorized SQL user for both databases.
- Then select "New User" from login Screen.
- Define SQL Server name.
- Select SQL Engine. Port number will be assigned automatically.
- Enter the IP Number of the server to be connected.
- Database Prefix must be entered to distinguish different databases kept in the same server.
- Company/Database Code must be entered to define the related company or database.
- SQL username and password must be entered to connect to the server inside Data Center. Username must contain the Database Prefix defined before.
- Click the "Connect" button to connect to the SQL server.