Sample Generic Data Source

• ODBC Section
• Data Sources Section
• Data Source datasourcename Sub-Section
• Dictionaries Section
• Dictionary dictionaryname Sub-Section
• Servers Section
• Server servername Sub-Section
• Complete Generic Data Source Example

ODBC Section

The ODBC is required for ODBC applications and any application that communicates to Omnidex via the Omnidex ODBC Gateway interface. This section will be ignored in JDBC and CLOA applications.

[ODBC] is the section identifier.

DRIVER=DISC OMNIDEX OdxNet Driver is the ODBC driver name registered with the Microsoft ODBC Driver Manager.

ODBCDSNFILE=D:\testing\dsn\odx_cal_ordersffl.dsn is the physical path and file name of this Generic data source.

ODBCDSNNAME=cal_orders is the data source name.

Data Sources Section

The Data Sources section lists the data source name of each data source defined within this data source file. At this time, only a single data source name can be defined here.

[DataSources] is the section identifier

cal_odxtest=DataSource Edit Wizard Generated is the data source name and description. The data source name is on the left and the description is on the right of the equal sign. The data source name will be the same as the ODBCDSNNAME in the ODBC section. The description is for informational purposes only.

DataSource datasourcename Sub-Section

Each data source name listed in the DataSources section must have its own sub-section. At this time, only a single data source can be defined within a single data source file, therefore, there will be only one data source sub-section.

[DataSource cal_orders] is the sub-section identifier

Dictionary=cal_orders - This statement links the data source to the dictionary declaration below.

DisplayWindow=NONE - This statement tells Omnidex client whether or not to display a pop up window when a connection is being established.

NetworkBufferSize=64 - Sets the default network buffer size.

InterruptRecord=0,100 -

ContinueInterrupt=1,5 -

RequireUserInfo=OFF - Require users to enter user name and password for all connections.

SaveUserInfo=OFF - Remember user login information.

ODBCUserName= Sets the default user name to be used for all client connections to this data source.

ODBCPassword= Sets the default password to be used for all client connections to this data source.

OdxOptimize=SERVER - Perform optimization on the SERVER or CLIENT.

OnOdxOptimizeError=DISALLOW -

OnCartesianRetrieval=DISALLOW - Allow or disallow cartesian product retrievals.

ShowRowID=ON - Include the Omnidex row id in the result set.

DisableScroll=OFF -

TrimChar=OFF -

TraceFile= Output filespec for client debug trace file.

TraceOverwrite=ON - Overwrite trace file if it already exists.

TraceClocks=ON - Include time passage information for each routine in the trace file.

TraceOutput=OFF -

Dictionaries Section

The Dictionaries section lists the dictionary name of each data source defined within this data source file. At this time, only a single dictionary can be defined here.

[Dictionaries] is the section identifier

cal_orders=DataSource Edit Wizard Generated is the dictionary name and description. The data source name is on the left and the description is on the right of the equal sign. The description is for informational purposes only.

Dictionary dictionaryname Sub-Section

Each dictionary listed in the Dictionaries section must have its own sub-section which defines information about the Omnidex environment catalog. At this time, only a single dictionary can be defined within a single data source file, therefore, there will be only one dictionary sub-section.

[Dictionary cal_orders] is the sub-section identifier

Server=Server1 - This statement links the dictionary to the Server declaration below.

NetworkServices=OdxNet - This statement indicates OdxNet will be used for network connections.

Type=OmniAccess -

DbDirect= This is specifically for TurboImage databases and is included for backward compatibility.

FileSpec=c:\omnidex\demo\orders.env - This is the fully qualified file name of the Omnidex environment catalog that this data source will connect to.

HostOAConnectOptions= Connect options to be passed with all connections through this data source.

Password=!~

AccessOptions=Write - All connections through this data source will have Read or Write access to the data.

Servers Section

The Server section lists the server name of each data source defined within this data source file. At this time, only a single server can be defined here.

[Servers] is the section identifier

Server1=DataSource Edit Wizard Generated is the server name and description. The server name is on the left and the description is on the right of the equal sign. The description is for informational purposes only.

Server servername Sub-Section

Each server listed in the Servers section must have its own sub-section which defines information about the host machine and network services listener port. At this time, only a single server can be defined within a single data source file, therefore, there will be only one server sub-section.

[Server Server1] is the sub-section identifier

Host=cal - This is the host name or IP Address that the Omnidex environment catalog is located on.

Port=1240 - This is the OdxNet listener port number running on the host that this data source will connect through.

Complete Sample Generic Data Source

[ODBC]
DRIVER=DISC OMNIDEX OdxNet Driver
ODBCDSNFILE=D:\testing\dsn\odx_cal_ordersffl.dsn
ODBCDSNNAME=cal_orders

[DataSources]
cal_orders=DataSource Edit Wizard Generated

[DataSource cal_orders]
Dictionary=cal_orders
DisplayWindow=NONE
NetworkBufferSize=64
InterruptRecord=0,100
ContinueInterrupt=1,5
RequireUserInfo=OFF
SaveUserInfo=OFF
ODBCUserName=
ODBCPassword=
OdxOptimize=SERVER
OnOdxOptimizeError=DISALLOW
OnCartesianRetrieval=DISALLOW
ShowRowID=ON
DisableScroll=OFF
TrimChar=OFF
TraceFile=
TraceOverwrite=ON
TraceClocks=ON
TraceOutput=OFF

[Dictionaries]
cal_orders=DataSource Edit Wizard Generated

[Dictionary cal_orders]
Server=Server1
NetworkServices=OdxNet
Type=OmniAccess
DbDirect=
FileSpec=c:\omnidex\demo\orders.env
HostOAConnectOptions=
Password=!~
AccessOptions=Write

[Servers]
Server1=DataSource Edit Wizard Generated

[Server Server1]
Host=cal
Port=1240

Top