Copyright: , 1995 INTERSOLV


	DataDirect ODBC  INGRES 6.4/04 Driver
Logon to INGRES

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


INGRES ODBC Setup
Configuring an INGRES 6.4/04 Data Source

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

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

Server Name:  The name of the virtual node that you defined using the INGRES NETU utility.  This virtual node tells INGRES which system to call, how to call it, and the user's name and password.

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

The following values are optional:

Server List:  The list of servers (virtual nodes) that will be available in the Logon dialog box.  Separate the server names with commas.

Database List:  The list of databases that will be available in the logon dialog box.  Separate the names with commas.

Default User Name:  The default user name used to connect to your INGRES database.  A user name 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.

Options:  Any flag allowed on the INGRES SQL command line.  Some examples are

•	-l (locks the database exclusively)

•	-u (logs on as username)

•	+w or -w (waits/doesn't wait for the database if a user has already opened it exclusively)

•	+U or -U (enables/disables user updating of the system tables and locks the database exclusively)

•	+Y or -Y (enables/disables user updating of the system tables but does not lock the database exclusively)

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

•	2 (INGRES' yield procedure), which uses INGRES' 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 2, the default.

Repeated Cache Size: A number that determines whether all Update and Insert statements are to be executed as repeated statements. This attribute improves the performance of applications that repeat the same SQL statement. When set to 0, the initial default, no statements are repeated. The recommended setting for this attribute is 100 (RepeatedCacheSize=100).

To repeat a single statement rather than all statements, use the INGRES REPEATED syntax.

Repeated Selects: A number that determines whether the driver optimizes Select statements or executes them as repeated queries. When set to 0, the initial default, the driver executes all Select statements as it did in previous versions of the product.

When set to 1, the driver optimizes Select statements that return only one result row. When set to 2, the driver executes all Select statements as repeated queries. If this attribute is set to 1 or 2, the RepeatedCacheSize attribute must be set to greater than zero.

Setting this option to 1 or 2:

has no effect on Select statements containing a For Update clause

limits the driver to one active statement and one active connection

Value Replacement for Repeated Selects: A number that determines whether the driver substitutes parameters for hardcoded values in repeated statements. This option is convenient in applications that do not use dynamic parameters.

When set to 0, the initial default, the driver doesnot substitute parameters. When set to 1, the driver substitutes parameters for hardcoded values and the RepeatedCacheSize attribute must be greater than zero or the REPEATED INGRES keyword must be used.

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 INGRES

Server Name:  Enter the server name of the computer containing the INGRES database you wish to access or select the name from the Server Name box, which displays the server names you specified in the Setup dialog box. Server Name must be a valid Virtual Node that has been added using the INGRES NETU utility.

Database Name:  Enter the name of the database to which you want to connect or select the name from the Database Name box, which displays the names you specified in the Setup dialog box.

User Name:  Enter your user name.

Options:  Enter any options for the connection. The options can be any flags allowed on the INGRES SQL command line.