Copyright

DataDirect Connect ODBC for SQLBase

© 1999 MERANT Solutions, Inc. All rights reserved.

INTERSOLV, DataDirect, SequeLink, and Middleware are registered trademarks of MERANT Solutions, Inc. DataDirect Connect ODBC, DataDirect Connect OLE DB, DataDirect Reflector, and WebDBLink, are trademarks of MERANT Solutions, Inc. Other company or product names mentioned herein may be trademarks or registered trademarks of their respective companies.


About Connect ODBC for SQLBase

Connect ODBC for SQLBase (the “SQLBase driver”) supports the Centura Software SQLBase database system in the Windows NT or Windows 9x environment.

The driver file name is IVGUPnn.DLL, where nn is the revision level.


System Requirements

To communicate with the server, the SQLBase driver requires SQLWNTM.DLL, SQLNGCI.DLL, and a communication DLL (for example, SQLNPIPE.DLL for Named Pipes). The directory containing these files must be on your path.

You must have version 6.x  or higher of SQLBase.


Configuring Data Sources

To configure a SQLBase data source, do the following:

1	Start the ODBC Administrator to display a list of data sources.

2	If you are configuring an existing data source, select the data source name and click Configure to display the ODBC SQLBase Driver Setup dialog box.

If you are configuring a new data source, click Add to display a list of installed drivers. Select SQLBase and click Finish to display the ODBC SQLBase Driver Setup dialog box.

3	Specify a data source name, a database name and optionally, a description. Click Apply.

4	Click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box.

5	Click the Advanced tab to configure optional data source settings, such as server name and server list. Click Apply.

6	Click Translate to display the Select Translator box, which lists the translators specified in the ODBC Translators section of the system information. DataDirect provides a translator named "OEM to ANSI" that translates your data from the IBM PC character set to the ANSI character set.

Select a translator, then click OK to close this dialog box and perform the translation.

7	Click OK or Cancel. If you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connecting to the data source using a connection string with alternate values.


Test Connect

At any point during the configuration process, you can click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box. A Logon dialog box is displayed. After providing connection information, click OK.

•	If the driver can connect, it releases the connection and displays a "connection established" message. Click OK.

•	If the driver cannot connect because of an improper environment or incorrect connection value, it will display an appropriate error message.

Verify that the all required client software is properly installed. If it is not, you will see the message:

Specified driver could not be loaded due to system error [xxx].

Click OK.


Connecting to SQLBase Using a Logon Dialog
Connecting to a Data Source Using a Logon Dialog

Some ODBC applications display a Logon dialog box when you are connecting to a data source.

In the Logon dialog box, do the following:

1	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 box, which displays the server names you specified in the Setup dialog box. Type Local to access a local SQLBase database.

2	Type the name of the database you want to access. If you specified a server name, you can select the name from the Database Name drop-down list box.

3	If required, type your user name.

4	If required, type your password.

5	Click OK to complete the logon and to update the values in the system information.


Connecting to a Data Source Using a Connection String
Connecting to Data Source Using a Connection String

If your application requires a connection string to connect to a data source, you must specify the data source name that tells the driver which section in the system information to use for the default connection information. Optionally, you may specify attribute=value pairs in the connection string to override the default values stored in the system information. These values are not written to the system information.

You can specify either long or short names in the connection string. The connection string has the form:

DSN=data_source_name[;attribute=value[;attribute=value]...]

An example of a connection string for SQLBase is:

DSN=SQLBASE TABLES;SRVR=IVSRVR;DB=PAYROLL;UID=JOHN;PWD=XYZZY

The paragraphs that follow give the long and short names for each attribute, as well as a description. The defaults listed are initial defaults that apply when no value is specified in either the connection string or in the data source definition in the system information. If you specified a value for the attribute when configuring the data source, that value is the default.

ApplicationUsingThreads (AUT): ApplicationUsingThreads={0 | 1}. Ensures that the driver works with multi-threaded applications. The default is 1, which makes the driver thread-safe. When using the driver with single-threaded applications, you may set this option to 0 to avoid additional processing required for ODBC thread safety standards.

CursorCacheSize (CCS): The number of cursors the cursor cache can hold. The cursor cache increases performance and uses few database resources. The initial default is 6.

Database (DB): The name of the database to which you want to connect.

DataSourceName (DSN): A string that identifies a SQLBase data source configuration in the system information. Examples include "Accounting" or "SQLBase-Serv1."

InputMessageSize (IMS): The number of bytes of the input message buffer. Increasing this value retrieves more records across the network in a single fetch. The initial default is determined by SQLBase.

LockTimeOut (LTO): The number of seconds SQLBase should wait for a lock to be freed before raising an error. Values can be -1 to 1800; -1 means wait forever. The initial default is 300.

LogonID (UID): The default logon ID (user name) used to connect to your SQLBase database. If so, contact your system administrator to get your logon ID. A logon ID is required only if security is enabled on your database.

NoRecovery (NR): NoRecovery={0 | 1}. A value that enables or disables transaction recovery. NoRecovery=0 (the initial default) enables recovery; NoRecovery=1 disables recovery. Warning: NoRecovery=1 improves performance but might cause your database to become inconsistent in the event of a system failure. See your SQLBase documentation for information on this option.

Password (PWD): A case-sensitive password.

ReleasePlan (RP): ReleasePlan={0 | 1}. 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 but will always allow you to Drop or Alter the table.

When set to 0, the default, no locks on tables are freed. When set to 1, locks are freed.

ServerName (SRVR): The name of the server containing the SQLBase database tables you want to access. Specify ServerName=Local if you are using the local server.

Servers (SRVRLIST): A comma-separated list of servers with which to prompt the user in a Logon dialog box. Specify Local to add the local server to the list.


Data Types

The SQLBase data types are mapped to the standard ODBC data types as follows:

SQLBase	ODBC
Char	SQL_VARCHAR
Date	SQL_TYPE_DATE
Decimal	SQL_DECIMAL
Double Precision	SQL_DOUBLE
Integer	SQL_INTEGER
Long Varchar	SQL_LONGVARCHAR
Number	SQL_DOUBLE
Real	SQL_REAL
Smallint	SQL_SMALLINT
Time	SQL_TYPE_TIME
Timestamp	SQL_TYPE_TIMESTAMP
Varchar	SQL_VARCHAR


Isolation and Lock Levels Supported

SQLBase supports isolation levels 1 (read committed, the default) and 3 (serializable). SQLBase also supports an alternative isolation level 1 called cursor stability. Your ODBC application can use this isolation level by calling SQLSetConnectOption (1040,1).

SQLBase supports page-level locking.


ODBC Conformance Level

The API functions supported are listed in Supported ODBC Functions, found in the General Help section of Connect ODBC Help. In addition, the following Level 2 functions are supported:

SQLColumnPrivileges

SQLForeignKeys

SQLPrimaryKeys

SQLProcedures

SQLSetPos

SQLTablePrivileges

The driver also supports backward and random fetching in SQLExtendedFetch and SQLFetchScroll. It supports the core SQL grammar.


Number of Connections and Statements Supported

The SQLBase database system supports multiple connections and multiple statements per connection.


General Tab, ODBC SQLBase Driver Setup

Use the ODBC SQLBase Driver Setup dialog box to create new SQLBase data sources or configure existing data sources.

Data Source Name: A string that identifies this SQLBase data source configuration in the system information. 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.

Advanced Tab

Displays the Advanced tab, where you can configure optional data source settings, such as file caching.

OK

Cancel

Apply

Test Connect


Advanced Tab, ODBC SQLBase Driver Setup

Use the Advanced tab on the ODBC SQLBase Driver Setup dialog box to specify optional settings when you create new SQLBase data sources or configure existing data sources.

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

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 but will always allow you to Drop or Alter the table. No locks on tables are freed when this option is set to the default, 0. Locks are freed when this option is set to 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. Warning: Selecting this box is may cause your database to become inconsistent in the event of a system failure.

Application Using Threads: A setting that ensures that the driver works with multi-threaded applications. You can clear this check box when using the driver with single-threaded applications. Turning off this setting avoids additional processing required for ODBC thread safety standards.

Translate Button

Displays the Select Translator dialog box, where you can translate your data from one character set to another. Choose the "OEM to ANSI" translator to translate your data from the IBM PC character set to the ANSI character set.

OK

Cancel

Apply

Test Connect


Logon to SQLBase Dialog

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 box, which displays the server names you specified in the Setup dialog box. Type 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 Database Name drop-down list box.

User Name: If required, type your user name.

Password: If required, type your password.


Apply Button

Writes the settings you have specified to the system information. These settings remain in effect until you change them in this dialog box. Clicking Cancel does not affect settings that have been applied.


OK Button

Writes the settings you have specified to the system information and closes the dialog box.


Cancel Button

Closes the dialog box without saving settings that have not been applied.


Contacting Technical Support

MERANT provides technical support for all registered users of this product, including limited installation support for the first 30 days. If you need support after that time, contact us using one of the methods below or purchase further support by enrolling in the SupportNet program. For more information about SupportNet, contact your sales representative.

World Wide Web
	http:/www.merant.com/datadirect/support The MERANT Web site contains up-to-date technical support information under SupportNet. SupportNet Online is our global service network that provides access to valuable tools and information in an online community for users. Our SupportNet Community shares information via the Web, automatic email notification, newsgroups, and regional user groups. SupportNet Online also includes a KnowledgeBase which allows you to search on keywords for technical bulletins and how-to information. You can also download fix releases for your DataDirect products.
Internet
	Australia and New Zealand	australia.answerline@merant.com
	EMEA	int.datadirect.answerline@merant.com
	Japan	jpn.answerline@merant.com.jp
	US and Canada	datadirect.answerline@merant.com
Telephone
Australia	1 800 335 664 or 9816 9977 for Melbourne Metro	8:30-5:30 p.m. Local Melbourne Time (LMT)
Belgium	0800 724 61	9:00-6:30 p.m. CET
France	0800 91 56 07	9:00-6:30 p.m. CET
Germany	0130 822 496 or  +44 1727 812898	9:00-6:30 p.m. CET
Japan	81-3-5401-9660	9:00-12:00, 1:00-5:00 p.m. JST
The Netherlands	0800 022 1609	9:00-6:30 p.m. CET
New Zealand	1 800 335 664	8:30-5:30 p.m. LMT
United Kingdom and Ireland	+44 1727 811881	8:00-5:30 p.m. GMT
USA and Canada	1 800 443 1601	8:30-8:00 p.m. EST
Fax US	1 919 461 4527
Fax Int.	+32-15-320919
Mail	1500 Perimeter Park Drive, Suite 100, Morrisville, NC 27560 USA

Information to Provide

When you contact us, include this information:

•	The product serial number located on the Product Registration Information card or on a product serial number card in the box. The number will be checked to verify your eligibility to receive support. If you do not have a current SupportNet contract, we will ask that you speak with a sales representative.

•	Your name and organization. On a first-time call, you may be asked for full customer information including location and contact details.

•	The version number of the DataDirect product you are using.

•	The type and version of the operating system you are using.

•	Any third party software and other environmental information necessary to understand the problem.

•	A brief description of the problem and the steps necessary to re-create it. Specific error messages are needed. Depending on the complexity of the problem, you may be asked to submit a recreatable example demonstrating the problem.

•	An assessment of the severity level of the reported problem.