Copyright: , 1995 INTERSOLV


	DataDirect ODBC  SQLBase Driver
Logon to SQLBase

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


SQLBase ODBC Setup
Configuring a SQLBase Data Source

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

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

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

The following values are optional:

Server Name:  The name of the server that contains the desired database.  Specify the word LOCAL if you are using the local server.

The server name is not required to log on.  The logon dialog box appears more quickly if you do not specify a server name.  If you do specify a server name, the Database Name drop-down list in the logon dialog box is populated with the names of the databases available on that server.

Server List:  A comma-separated list of servers that will appear in the Logon dialog box.  Specify LOCAL to add the local server to the list.

Default User Name:  The default user name used to connect to your SQLBase 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 or connection string.

Cursor Cache Size:  The number of cursors the cursor cache can hold.  The default is 6.

Yield Proc:  A numeric value that determines whether you can work in other applications when SQLBase 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 	(SQLBase's yield procedure), which uses SQLBase'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.

Input Message Size:  The number of bytes in the input message buffer.  The default is determined by SQLBase.  Increasing this value retrieves more records across the network in a single fetch.

Lock Time Out:  The number of seconds SQLBase should wait for a lock to be freed before raising an error.  Values can be -1 (wait forever) to 1800; the default is 300.

No Recovery:  Select this check box to disable transaction recovery.  Selecting this box is dangerous because your database can become inconsistent in the event of a system crash.

Release Plan:  A number that determines whether a lock is maintained on a table when the cursors accessing the table are freed. Freeing the lock on the table results in a request to the server, which can decrease performance. No locks are freed when this option is set to the default, 0. Locks are freed when this option is set to 1.

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 SQLBase

Server Name:  Optionally, type the name of the server containing the SQLBase database tables you want to access or select the name from the Server Name drop-down list, which displays the server names you specified in the Setup dialog box. Type the word LOCAL to access a local SQLBase database system.

Database Name:  Type the name of the database you wish to access or select the name from the the Database Name drop-down list.

User Name:  If required, type your user name.

Password:  If required, type your password.