Skip to end of metadata
Go to start of metadata

Use the SQL Database Information section of the VXGate Config dialog box to set server, user account detail and SQL database name. This section also provides access to SQL editing tools, in which to define BDAP and User queries. The example screen shown below demonstrates information presentedwhen the Edit SQL Scripts dialog box is in BDAP mode. Clicking the User Queries button at the base of the Edit SQL Scripts dialog box results in immediate transformation of the presentation to the User Queries version of the dialog box.

SQL Database Information Dialog Fields

Field

Description

Server

The address of the SQL server. This field is valid only when used in the ODBC Connect.

Database

The name of the database on the SQL server. This field is valid only when used in the ODBC Connect.

UserName

The name of the user that VX gate will use to log into the database. This field is valid only when used in the ODBC Connect.

Password

The password for VX gate login user. This field is valid only when used in the ODBC Connect.

Maximum Number of CDR Threads

The number of threads to log CDRs. The default is 5. Increasing the number of threads for logging CDRs might improve performance under certain circumstances. However, it is not usually necessary to change this value

Maximum CDR Queue Depth

The number of requests that must be pending before a new thread is started. The default is 30. It is not usually necessary to change the default.

Edit SQL [button]

The Edit SQL Scripts dialog box is where you can edit the available queries executed by the VXgate.

SQL Configuration Dialog

Edit SQL Scripts Dialog

Field

Description

Startup Script

Plain text file containing SQL commands, separated by the word `go' on its own line. VX gate executes this script against the database each time it starts.
To bypass the startup script, remove all information from the Startup Script field.

ODBC Connect String

This string is used to establish the connection with the database manager. The default setting, which may be set by clicking the D button, is suitable for connecting to a Microsoft SQL Server. There are four keywords that can be specified within this string, each referring to the appropriate settings on the main form:

~SERVER--Name of server at which connection is to be established.
~USER --Login account ID.
~PASSWORD --Password to be used for authentication.
~DATABASE --Database to use when connection established.

These fields are filled in automatically at connect time from the fields on the main form.
It is not necessary to use all of these but it is necessary to provide enough information for a successful login to the database.
If no string is specified, VXgate will not attempt to connect to an ODBC data source. However, it will still answer manual ODBC requests made by scripts running on VX

CDR Time Format

CDR Time Format specifies a format string which represents how VXgate will represent timestamps to the SQL server. Pressing the'D' button will allow you to choose one of two default formats described below.

1) The full ('Router') timestamp will set the string to:%H:%M:%S.000 UTC %a %b %d %Y
This will look like: 15:48:22.000 UTC Tue Jan 28 2004

2) The abbreviated ('SQL') timestamp will set it to: %d %B %Y %H:%M:%S
This will look like: 28 January 2004 15:48:22

A summary of available time fields may be displayed by clicking the '?' button.

BDAP Queries [button]

BDAP Queries Button selects the BDAP Query Edit page .

User Queries [button]

User Queries Button selects the User Query Edit page. There are 10 user queries (numbered 0-9) available from VXscript. This page allows editing of their functions. These queries are free-form, may be action or select queries, and may return at most one value. Up to five arguments may be provided by the script. These arguments are treated as strings and unverified by the system. Care should be taken in their use.

  • No labels