Copyright: , 1995 INTERSOLV


	DataDirect ODBC  MicroDecisionware Driver
Configuring an MDI Data Source

Logon to MDI

Copyright


Copyright
Copyright 1995 INTERSOLV Inc. All rights reserved. INTERSOLV is a registered trademark, and DataDirect is a trademark of INTERSOLV, Inc. Other company or product names mentioned herein may be trademarks or registered trademarks of their respective companies.


MDI ODBC Setup
Configuring an MDI Data Source

Data Source Name:  A string that identifies this MicroDecisionware data source configuration in ODBC.INI.  Examples include "Accounting" or "MicroDecisionware Serv1."

Description:  An optional long description of a data source name.  For example, "My Accounting Database" or "MicroDecisionware on Server number 1."

Server Name:  The name of the OS/2 server running the MicroDecisionware Database Gateway.  This value will appear as the initial default in the logon dialog box.

The following values are optional:

Server List:  The list of servers that will appear in the logon dialog box.  Separate the server names with commas.

Default Authorization ID:  The default authorization ID used to connect to your DB2 database.  This ID is case-sensitive.  An authorization ID is required only if security is enabled on your database.  Your ODBC application may override this value or you may override this value in the logon dialog box.

Groups:  A list of the groups to which you belong, used to determine which tables you can access.  Separate each group name with a comma.  Alternatively, enter the word ALL so that you can see all table names even if you cannot access the table.

Application Name:  The name used to identify your application.

Workstation ID:  The workstation ID used by the MicroDecisionware Database Gateway.

Cancel Behavior:  A value to specify how a previously executed statement should be canceled.

•	0 fetches all remaining records if the statement was a Select.

•	1 cancels the statement by calling dbcancel.  This is the default.

•	2 closes the connection to the server for the statement.

Yield Proc:  A numeric value that determines whether you can work in other applications when the gateway is busy.  This attribute is useful to users of ODBC applications.  Valid values are:

•	0 (peek and dispatch), which causes the driver to check the Windows message queue and send any messages to the appropriate Windows application.

•	1 (no yielding, the default), which does not let you work in other applications.

•	3 (dispatch via Windows Yield function), which turns control over to the Windows kernel.  The Windows kernel checks the message queue and sends any messages to the appropriate application window.

It is recommended that you use the value 1.  The values 0 and 3 do not work with all Windows applications.

Owner of Catalog Tables:  The owner of views of the system tables.  The tables themselves are owned by SYSIBM.  If you have read access to the system tables, this option does not have to be changed.  If you do not have read access, the database administrator must create a view of the system tables in another account and give you permission to use the view.  Enter the authorization ID for the account that owns the views for the system tables.

Tablespace to Create Tables in:  The name of the tablespace in which new tables are stored.  For example, DSNDB04.

DB2 Site Allows User to Log On More Than Once:  A check box that specifies that your site lets a user log on to DB2 more than once.  Selecting this check box may improve performance.

NETAPI.DLL Library Available:  A check box that specifies that the driver can use NETAPI.DLL to get the name of your workstation.  Most major PC networks support this feature.  If your network does not support this capability, deselect this option.  If you supply a workstation ID, this setting is ignored.

Translate: Displays the Select Translator dialog box to allow you to perform a translation of your data from one character set to another. Choose the INTERSOLV OEM ANSI translator to translate your data from the IBM PC character set to the ANSI character set.


Logon to MDI

Server Name:  Enter the name of the OS/2 server running the Database Gateway you wish to access or select the name from the Gateway Server box, which displays the server names specified in the Setup dialog box.

Login ID:  Enter your Authorization ID (case-sensitive).

Password:  Enter your password for the system (case-sensitive).