Using a Connect String
A connection string describes the attributes of an ODBC connection. An example connection string would be:
DRIVER={Dimensional Insight ODBC Driver (32bit)};SERVER=
diver.mycompany.com;USERNAME=asmith;PROJECT=Sales;CBASE=/client_files/sales.cbase
Attributes are separated by semicolons. The attribute keys are case-insensitive. Each key is followed by an equals sign and then the attribute value. Attribute values can be surrounded with braces.
DI-ODBC supports the following attributes.
Attribute | Description |
---|---|
DRIVER |
If present, this must be set to Dimensional Insight ODBC Driver (32-bit) or Dimensional Insight ODBC Driver (64-bit), depending on the architecture of the application being used. Exactly one of DSN or DRIVER must be present. |
DSN |
If present, this must be set to a DSN created in the Windows ODBC Data Sources dialog. Other attributes included in the connection string will override the DSN attributes. Exactly one of DSN or DRIVER must be present. |
SERVER |
The DiveLine server hostname. If absent, the user will be prompted to connect to a DiveLine server. |
PORT | The DiveLine server port number. If absent, the default port number of 2130 will be used. |
USERNAME |
The DiveLine username. If either USERNAME or PASSWORD are absent, the user will be prompted to log in, unless single sign-on is configured. |
PASSWORD |
The password for the user specified in the USERNAME attribute. See Password for DI-ODBC. If either USERNAME or PASSWORD are absent, the user will be prompted to log in, unless single sign-on is configured. |
PROJECT |
The DiveLine project to find the dive script in. If PROJECT is absent, the user will be prompted to select a file. |
CBASE |
The project path of a cBase to use. See Source Type Details for the Driver for more info about cBases. NOTE: The CBASE attribute is not valid when connecting to DiveLine version 7.0. If CBASE, CPLAN, and DIVE are all absent, the user will be prompted to select a file. At most one of CBASE, CPLAN, or DIVE can be present. |
CPLAN |
The project path of a cPlan to use. See Source Type Details for the Driver for more info about cPlans. If CBASE, CPLAN, and DIVE are all absent, the user will be prompted to select a file. At most one of CBASE, CPLAN, or DIVE can be present. |
DIVE |
The project path of a Dive script. See Source Type Details for the Driver for more info about Dive scripts. If CBASE, CPLAN, and DIVE are all absent, the user will be prompted to select a file. At most one of CBASE, CPLAN, or DIVE can be present. |
REGISTRY | If using an ODBC registry this must be set to 1. |