All of these storage settings need to be determined for your environment. If you are using the Bourne or Korn shell, type: In the Service Name field, type the service name you want to use for the new SequeLink service. If you want to use a connection string for connecting to a database, or if your application requires it, you must specify either a DSN data source name or a DSN-less connection in the string. If the database name DB contains a semicolon ; , you must place the name in quotes, as shown in the preceding example. In the connection string. When set to 2, the driver reports that qualifiers are not supported.

Uploader: Nebei
Date Added: 15 December 2012
File Size: 60.77 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 87991
Price: Free* [*Free Regsitration Required]

The Select Translator dialog box appears, listing translators specified in the ODBC Translators section of the system information file. When you are setting up your server to use the CAF attachment, you must grant access to the SequeLink plan for all users who will connect to the SequeLink Server. If example is unable to connect, the appropriate error message appears.

Ensure the UID connected to either process has authority to access the SequeLink installation directories. The list includes long and short names and provides a description of each attribute. DB2 threads owned by any other application are never canceled. This mode is not supported by the Quick Install feature; the Quick Install feature supports only data source files created with the Merge or Overwrite options.


The first stage of the connection process involves establishing a network connection. File data sources are data source files stored on a file server. Enter the setting for the environment variable and its value. In the connection string In the Data Source section of the system information file odbc. Once the connection information is retrieved, the SequeLink Client will connect directly to the specified SequeLink Server.

8 Configuring the ODBC Client

A default installation of SequeLink Server uses the port Tuning can make a significant difference in the performance of your application. Click Next and continue with Step 5.

Because UNIX is a multi-user environment, you may want to use a single centralized odbc. Connections to a data source can be made via a connection string without referring to a data source name DSN-less connections. To configure the file data source to retrieve connection information from an LDAP directory, continue with sequelin, next step. You are returned to the list of drivers.

Select DataDirect SequeLink 6. If this validation fails, the SequeLink Server will attempt to authenticate the user ID and password with the database account defined for the domain of the machine on which the SequeLink Server is running.

The window title bar of datdirect SequeLink Data Source SyncTool indicates whether you, or the end user, is performing an export or an import operation. This attribute is only required when the SequeLink service you are connecting to has been configured to limit access to specific applications. For more information about the ivcheckjdbcdriver utility, refer to the SequeLink Troubleshooting Guide and Reference.


If successful, a dialog appears telling you the connection was successful.

Merge mode adds or updates all the daadirect sources in the data source file without deleting other data sequelinm. When set to 2, output parameters are returned after a SQLFetch is complete. The default extension for data source files is. This chapter describes how to create a SequeLink service and how to configure SequeLink services for specific databases:. The output destination of these messages is controlled by the syslog daemon.

When set to 2, the driver reports that qualifiers are not supported. If you want to put the odbc.

15 Configuring SequeLink® Services for Your Database

ODBC provides maximum interoperability-a single application can access many different database systems. How the database data types are mapped depends on the database and a number of configuration options.

Type the name of the file data source you want to create sequelnk click Browse to select an existing file data source; then, click Next.