Copyright: , 1995 INTERSOLV


	DataDirect ODBC  INFORMIX 5 Driver
Logon to INFORMIX

INFORMIX Logon Options

INFORMIX ODBC Setup

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.


INFORMIX 5 ODBC Setup
Configuring an INFORMIX 5 Data Source

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

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

Database Name:  The name of the database to which you want to connect by default.

The following values are optional:

Database List:  The list of databases that will be displayed in the logon dialog box.  Separate the names with commas. If Get DB List From Informix is set to 1, the list of databases that will be displayed in the logon dialog box is created from the database list returned for INFORMIX at logon time.

When you specify databases, separate the names with commas.

Default User Name:  The name of the user as specified on the INFORMIX 5 server.

Host Name:  The name of the machine on which the INFORMIX 5 server resides.

Service Name:  The name of the service as it appears on the host machine.  This service is assigned by the system administrator.  The name you specify is displayed in the INFORMIX Server Options dialog box.

Protocol Type:  The protocol used to communicate with the server.  Specify one or more values; separate the names with commas.  Values can be FTP, IPX, LANMAN, TCP-IP.  This list is displayed in the Logon Options dialog box.

Yield Proc:  A numeric value that determines whether you can work in other Windows applications when INFORMIX 5 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.

•	2 (INFORMIX's yield procedure), which uses INFORMIX's default yield procedure.

•	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.

Cursor Behavior:  Select Preserve if you want cursors to be held at the current position when the transaction ends.  Otherwise, leave this set to Close.  Selecting Preserve may impact the performance of your database operations.

Enable Scrollable Cursors:  A value that determines whether the driver can use scrollable cursors. The initial default value is 0 (no use of scrollable cursors). The INFORMIX driver can use scollable cursors only if there are no long columns (SQL_LONGVARCHAR or SQL_LONGVARBINARY) in a Select list. If you set this option to use scrollable cursors (EnableScrollableCursors=1), you must not include long columns in the Select list.

Get DB List from Informix:  A value that determines whether the driver requests the database list to be returned from the INFORMIX server or from the database list that the user entered at driver setup.

When set to 1, the default, the driver requests the database list from the INFORMIX server. When set to 0, it uses the list entered by the user at driver setup.

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 INFORMIX 5

Database Name:  Type the name of the database you want to access or select the name from the Database Name drop-down list. This list displays names returned from the INFORMIX server. Or, if you set the Get DB List from Informix option to 0 in the Setup dialog box, this list displays the names you specified.

Host Name:  Enter the name of the machine on which the INFORMIX 5 server resides.

User Name:  Enter the name of the user as specified on the INFORMIX 5 server.

Password:  Enter the user's password.

Click Options to specify the Service Name and Protocol type.


INFORMIX 5 Server Options
INFORMIX 5 Logon Options

Service Name:  Name of the service as it appears on the host machine. This service is assigned by the system administrator. If you entered a service name in the Setup dialog box, that name is displayed; you can change it.

Protocol Type:  This list displays the protocols specified in the Setup dialog box. Select a communications protocol.