Connection

The Connection tab contains the majority of the settings for the ODBC driver.

The following table describes the function of each setting, as well as recommended use-cases:

Table 1. 1010data ODBC driver: Connection tab
ODBC Driver Setting/Linux Key Default Value Brief Description Use Case
DSN

{DSN}
www2.1010data.com A unique name for the ODBC driver connection. Keep the default value unless there is a specific reason you need to change it.
Host

{Host}
www2.1010data.com The domain name of the server/service your computer connects to when using an ODBC connection. Keep the default value, unless you need to use a specific version of 1010data. If you do need to use a specific version, specify it here (i.e., www2.1010data.com/cgi-bin/{VERSION}/gw.k).
User ID

{UID}
blank The 1010data user name of the person/computer connecting to the database. If the application you're using sends authentication information, this field will be overwritten. In such a case, it doesn't matter if this field is populated or not.
Password

{PWD}
blank The password for the 1010data account used in this connection. If the application you're using sends authentication information, this field will be overwritten. In such a case, it doesn't matter if this field is populated or not.
Port

{Port}
443 The TCP/IP port on which the 1010data servers establish ODBC connections Keep the default, or change to '80' if you don't want to send encrypted information. For instance, if you are connecting to 1010data via a secure VPN connection, you can safely change the port to 80.
Kill prior session

{KillP}
No If there is an active 1010data session when you log in, this option controls the behavior. If No, an error will be returned. If Yes, the session will be terminated and a new session will be established. If Possess, the existing session will be taken over by the ODBC interaction.  
Reconnect?

{Persist}
Unchecked If the current session times out, attempt to reconnect to the 1010data session.  
Binary mode

{BinaryP}
Checked Sends all data in binary form instead of ASCII. Keep the default unless you have a specific reason to change it. Binary data sends and receives more quickly than ASCII data.
Compression

{Compression}
Checked Send data using compression algorithms to improve send/receive times. Keep the default unless you have a specific reason not to send compressed data.
Treat root dirs as schemas

{Schematize}
Unchecked Tells the ODBC driver to treat root directories in the 1010data system as schemas would be treated in a relational database. In an SQL database, schemas contain tables, while in 1010data, directories contain tables. Use this option if your application requires schemas to function.
Download Window Size

{Window}
1000000 Sets the default number of records or rows downloaded to the local system each time the local system receives information.  
Root Folder (Optional)

{Database}
Blank Provides a root folder/directory where all subsequent folders/tables will be assumed to be located.
Note: The Mangle pathnames checkbox must be checked for this option to work.
Note: The root folder name must contain an '@' symbol before the name. See the screenshot preceeding this table for an example.
If you are working in a table or set of tables that all share the same root directory, you can provide the name of that root directory here so that it doesn't need to be typed every time.
Mangle pathnames

{Mangle}
Unchecked In SQL, both the underscore (_) character, and the period (.) character are valid as folder delimiters. In 1010data, the period (.) character is used for this purpose. This setting performs a "fuzzy" search for underscore delimiters in an SQL folder path and replaces underscores identified as delimiters with periods.
Note: This setting is also required for the use of Stored Procedures.
If the programmatically generated SQL code produced by your applications uses underscores as folder delimiters, you should check this box.
Note: Using this feature can degrade client performance when large numbers of objects are visible in the database.
Group Name

{GRP}
Blank This value specifies the name of the SAM pool group you use for shared access management.  
Retry Get UID if system is busy

{LoopGetUID}
Unchecked If all the SAM pool resources for your group (i.e., the preset number of user IDs available) are in use, the system will attempt to reconnect until a connection is made.  
Clear cache if workspace is greater than n MB

{ClearCache}
Blank For SAM pools, a UID's resources remain allocated even after the session has ended.

When this setting is checked, if a new connection is made with the same UID, and the workspace size has exceeded the limit specified by this setting, the system will clear the memory being used by the existing session and establish a fresh workspace.

 
{XFF}
Empty This value stores the IP address given from a user machine to a proxy application. If you are building an application that acts as a proxy between users and 1010data, 1010data suggests you use this value to pass a user's origin IP address for logging purposes.
If you're using a proxy to connect, prepend your host URL with the proxy credentials in square brackets []. For example:
[http://PROXYUSERNAME:PROXYUSERPASSWORD@www.corporateproxyserver.com:8080]
https://www2.1010data.com
This does not support auto-proxy.