OpenLink Universal Data Access Drivers for Windows/Unix Viewlets

OpenLink Type-3 JDBC: a Traditional Client/Server Connection Using an Applet

OpenLink Product Support (howtos@openlinksw.com) — Mon, 24 Nov 2003 23:35:13 GMT

Connect to your Oracle database using a Java applet stored on your web server. The OpenLink Type-3 archictecture allows you to connect to your database in one of two ways: client/server and 3-tier. This demo will illustrate the former method.

Recommended Screen Resolution: 1024x768

OpenLink Type-3 JDBC: Using Your Web Server as a Gateway

OpenLink Product Support (howtos@openlinksw.com) — Mon, 24 Nov 2003 23:35:34 GMT

Connect to your Oracle database using a Java applet stored on your web server. The OpenLink Type-3 archictecture allows you to connect to your database in one of two ways: client/server and 3-tier. This demo will illustrate the latter method.

Recommended Screen Resolution: 1024x768

OpenLink ODBC 2-Tier Configuration: Starting the Request Broker in Debug Mode

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:17:33 GMT

Learn how to start up the OpenLink Request Broker in debug mode on a remote Unix database server. Telnet to server and run startup in command-line mode.

Recommended Screen Resolution: 1024x768

OpenLink ODBC 2-Tier Configuration: Configuring the Database Agent via the Admin Assistant

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:17:55 GMT

Configure the OpenLink Database Agent for Oracle using the HTTP-based Admin Assistant.

Recommended Screen Resolution: 1024x768

OpenLink ODBC 2-Tier Configuration: Testing a Connection in the ODBC Data Sources Administrator

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:18:11 GMT

Test the Oracle database connection via the Windows ODBC Data Sources Administrator.

Recommended Screen Resolution: 1024x768

OpenLink ODBC 3-Tier Configuration: Connecting to Oracle

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:18:22 GMT

Configure and connect to Oracle using OpenLink's 3-tier architecture. Requires Net 8 Service Name created to which the Openlink Agent for Oracle will connect, thus avoiding the necessity to install OpenLink on the database server.

Recommended Screen Resolution: 1024x768

OpenLink ODBC 3-Tier Configuration: Connecting to Progress

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:17:19 GMT

Configure and connect to Progress 8 using OpenLink's 3-tier architecture. Requires -S, -H, and -N options in Connect Options field. As a prerequisite the service name must be created. This configuration avoids the necessity to install OpenLink on the Progress database server.

Recommended Screen Resolution: 1024x768

OpenLink ODBC 3-Tier Configuration: Connecting to MS-SQL Server

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:23:19 GMT

Configure and connect to MS-SQL Server 7 using OpenLink's 3-tier architecture. Requires a SQL Server service name configured, to which the Openlink Agent for SQL Server will connect, thus avoiding the necessity to install OpenLink on the database server.

Recommended Screen Resolution: 1024x768

Access: Create Pass-Through Queries

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:37:40 GMT

Microsoft Access Pass-Through Queries pass specific, hand-coded SQL statements to databases. Access does not generate SQL for users. This presentation teaches users how to run their own Pass-Through Queries.

Recommended Screen Resolution: 640x480

Admin Assistant: Hardcode Connection Parameters

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:38:10 GMT

You may hardcode connection parameters in your Session Rules Book. Hardcoded parameters override parameters passed in the user's DSN. This provides you with a measure of convenience and/or security. This presentation teaches you how to proceed.

Recommended Screen Resolution: 640x480

Admin Assistant: Change Database Agents

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:38:36 GMT

This presentation teaches you how to change or add database agent executables to your OpenLink Session Rules Book.

Recommended Screen Resolution: 640x480

Admin Assistant: Create ODBC Data Sources

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:38:58 GMT

This presentation teaches you how to create ODBC Data Sources with the Multi-Tier Admin Assistant.

Recommended Screen Resolution: 640x480

Admin Assistant: Enable & Disable OPSYSLOGIN

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:39:23 GMT

OpenLink's OPSYSLOGIN feature provides an alternative to database username/password authentication. Users may enable OPSYSLOGIN to insure that usernames and passwords are validated against operating system security files. This presentation teaches you how to enable--or disable--OPSYSLOGIN.

Recommended Screen Resolution: 640x480

Admin Assistant: Set Database Agent Environment Variables

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:39:48 GMT

OpenLink's database agents use certain database-specific environment variables to establish their connections. This presentation teaches you how to locate and configure these environment variables.

Recommended Screen Resolution: 640x480

Admin Assistant: Hardcode the Broker IP Address

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:40:12 GMT

This presentation teaches you how to hardcode your Request Broker IP Address. Hardcoded IP Addresses are beneficial, if a server contains multiple network cards.

Recommended Screen Resolution: 640x480

Admin Assistant: Enable Jetfix

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:40:37 GMT

OpenLink's +jetfix option facilitates translation of MONEY and other data types by the MS Access and MS Jet. This presentation teaches you how to enable +jetfix.

Recommended Screen Resolution: 640x480

Admin Assistant: View Broker & Agent Licensing

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:40:45 GMT

This presentation teaches you how to view the terms of your Multi-Tier broker and agent licenses.

Recommended Screen Resolution: 640x480

Admin Assistant: Change the Broker's Max Agents Setting

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:41:12 GMT

The Multi-Tier Max Agents parameter controls the number of database agents that a Request Broker may spawn. This presentation teaches you how to change that setting.

Recommended Screen Resolution: 640x480

Admin Assistant: Enable or Disable PingWatchDog

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:41:34 GMT

PingWatchDog helps users reclaim licenses when crashed client machines do not clean up agent connections. This presentation teaches users how to enable and disable the PingWatchDog feature.

Recommended Screen Resolution: 640x480

Admin Assistant: Prevent Access Admin Account Errors

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:41:44 GMT

This presentation teaches you how to prevent Access "Reject admin user account is not registered" errors.

Recommended Screen Resolution: 640x480

Admin Assistant: Change Your Database Agent Reuse Rules

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:42:10 GMT

OpenLink Product Support may ask you to change your database agent reuse rules. Reuse rules control the number of database connections that an agent will handle. This presentation teaches you how to proceed.

Recommended Screen Resolution: 640x480

Admin Assistant: Manage OpenLink TCP Port Usage

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:42:35 GMT

This presentation teaches you how to manage your OpenLink TCP port usage.

Recommended Screen Resolution: 640x480

Relinking: Relink OpenLink Database Agents (Non-Progress)

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:42:44 GMT

This presentation teaches you how to relink OpenLink's database agents. Progress users should view Progress-specific relink instructions.

Recommended Screen Resolution: 640x480

Client Receive Timeout: Change Your Client Settings

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:42:55 GMT

OpenLink Product Support may ask you to raise your Client Receive Timeout in an attempt to debug large query timeouts. This presentation teaches you how to proceed.

Recommended Screen Resolution: 640x480

Using C++ Demo

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:43:11 GMT

This presentation teaches OpenLink staff to use C++ Demo for QA and other purposes.

Recommended Screen Resolution: 640x480

DTS Wizard: Import ODBC Data With SQLServer's DTS Wizard

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:44:43 GMT

The SQLServer DTS Wizard enables users to import 3rd-party data into SQLServer databases. This presentation teaches you how to import data with the DTS Wizard and OpenLink's ODBC drivers.

Recommended Screen Resolution: 640x480

Request Broker: Standard and Emergency Shutdown

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:45:28 GMT

The OpenLink Request Broker is service. Users may stop and start it with various utilities. This presentation teaches you how to perform standard and emergency Broker shutdowns.

Recommended Screen Resolution: 640x480

Licensing: Apply Multi-Tier Licenses on Unix

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:46:06 GMT

You need a temporary or commercial license to operate OpenLink's Request Brokers and database agents.This presentation teaches you how to license a Unix server.

Recommended Screen Resolution: 640x480

Access: Link Tables into Microsoft Access

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:46:14 GMT

This presentation teaches you how to link 3rd-party database tables into Microsoft Access.

Recommended Screen Resolution: 640x480

Environment Variables: Use Export to Change or Append to Variables

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:46:50 GMT

This presentation teaches you how to use the Unix update command to change or append to existing environment variables.

Recommended Screen Resolution: 640x480

Linked Servers: Create SQLServer Linked Servers

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:47:02 GMT

The SQLServer Linked Servers interface allows users to query third-party databases with SQLServer. This presentation teaches you how to use Microsoft's SQLServer Linked Server utility--and OpenLink Drivers--to query these databases.

Recommended Screen Resolution: 640x480

MSQUERY: Query 3rd Party Databases with MSQUERY

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:47:12 GMT

This presentation teaches you how to query 3rd-party databases with Microsoft MSQUERY.

Recommended Screen Resolution: 640x480

Sybase & MS SQLServer: Connect To Multiple DSQUERIES

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:48:19 GMT

This presentation teaches you how to connect to multiple DSQUERIES.

Recommended Screen Resolution: 640x480

ODBC Agent: Create ODBC Agent Data Sources

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:48:40 GMT

This presentation teaches you how to establish ODBC connections to Access, DBase, FoxPro, Paradox, and other databases for which OpenLink does not provide a specific database agent.

Recommended Screen Resolution: 640x480

odbccat8: Load odbccat Scripts Into Oracle

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:48:50 GMT

The odbccat scripts allow OpenLink's Oracle database agents to take advantage of high performance catalog calls and additional scalar functions, for which Oracle has no direct support. This presentation teaches you how to use odbccat scripts to optimize your ODBC to Oracle experience.

Recommended Screen Resolution: 640x480

odbctest: Test OpenLink ODBC Connections

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:49:02 GMT

Odbctest is a test application which ships with OpenLink's Unix and Linux drivers. It is used to perform basic connection tests and queries. This presentation teaches you how to use OpenLink's odbctest utility.

Recommended Screen Resolution: 640x480

oplshut: Use oplshut to Control Broker & Agent Activity

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:49:33 GMT

The Multi-Tier oplshut utility allows users to reinitialize the Request Broker, shutdown the Request Broker, and monitor agent usage. This presentation teaches you how to use oplshut.

Recommended Screen Resolution: 640x480

PivotTables: Create Excel PivotTables with UDA Drivers

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:50:18 GMT

This presentation teaches you how to build Excel PivotTables, which leverage the power of OpenLink's UDA drivers.

Recommended Screen Resolution: 640x480

Probuild: Relink OpenLink Agents With Progress's Probuild Utility

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:50:49 GMT

This presentation teaches you how to relink OpenLink database agents with the Progress probuild utility.

Recommended Screen Resolution: 640x480

Progress: Configure the Progress _User File

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:51:02 GMT

This presentation teaches you how to configure the Progress _User file. The _User file is associated with -U and -P ODBC errors.

Recommended Screen Resolution: 640x480

Relinking: Relink Progress Database Agents (Standard)

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:51:11 GMT

OpenLink's relink process rebuilds your database agent against the database that you actually use. This procedure removes any disparities that may prohibit optimal interaction between your agent and database. This presentation teaches you how to relink Progress database agents.

Recommended Screen Resolution: 640x480

Request Broker: Create, Modify, or Delete Broker Services

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:51:19 GMT

OpenLink's Windows-based Request Brokers install themselves as services. However, you may want to create additional services, or you may need to delete and recreate an existing service to troubleshoot a problem. This presentation teaches you how to manipulate OpenLink's Request Broker services.

Recommended Screen Resolution: 640x480

Rowset Viewer: Test OpenLink's OLE DB Provider

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:51:28 GMT

OpenLink Software provides an OLE DB provider for Windows clients. This presentation teaches you how to test this provider with OpenLink's "Rowset Viewer" test application.

Recommended Screen Resolution: 640x480

Tableview: Run Tableview on Unix

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:51:40 GMT

OpenLink's tableview scripts enable users to query Progress arrays and to connect to multiple, Progress databases with one data source. This presentation teaches you how to create tableview .dat and .pf files.

Recommended Screen Resolution: 640x480

Security: Enable Enhanced Multi-Tier Security

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:51:48 GMT

This presentation teaches you how to enable OpenLink's enhanced Multi-Tier security.

Recommended Screen Resolution: 640x480

Isolation Levels: Set Multi-Tier Isolation Levels

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:52:07 GMT

This presentation teaches you how to set your database isolation levels with OpenLink's Multi-Tier drivers.

Recommended Screen Resolution: 640x480

Environment Variables: Use set to Set OpenLink ODBC Variables

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:52:08 GMT

Many OpenLink support cases are associated with missing or misconfigured environment variables. This presentation teaches you how to test your environment settings and send your settings to OpenLink Product Support.

Recommended Screen Resolution: 640x480

SQL Server: Eradicate ANSI_NULLS Errors

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:52:12 GMT

This presentation teaches you how to eradicate SQL Server ANSI_NULLS errors.

Recommended Screen Resolution: 640x480

Request Broker: Start the Broker Services

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:52:29 GMT

This presentation teaches you how to start the Multi-Tier Request Broker service.

Recommended Screen Resolution: 640x480

Single-Tier: Install Single-Tier Drivers on Unix

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:54:28 GMT

This presentation teaches you how to install OpenLink's Single-Tier drivers on Unix operating systems.

Recommended Screen Resolution: 640x480

openlink.sh: Set OpenLink Environment Variables

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:54:55 GMT

This presentation teaches you how to set OpenLink Software environment variables with openlink.sh and openlink.csh.

Recommended Screen Resolution: 640x480

VBDemo: List & Query Database Tables

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:55:01 GMT

This presentation teaches you how to use VBDemo to list and query database tables.

Recommended Screen Resolution: 640x480

Single-Tier Drivers: Windows Installation

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:55:33 GMT

This presentation teaches you how to run OpenLink's Single-Tier installers on Windows operating systems.

Recommended Screen Resolution: 640x480

Environment Variables: Set Variables on Windows

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:55:43 GMT

Windows users may need to set certain environment variables to facilitate use of OpenLink's ODBC drivers. This presentation explains the process.

Recommended Screen Resolution: 640x480

Admin Assistant: Configure Ports, Authentication & Logging

OpenLink Product Support (howtos@openlinksw.com) — Tue, 25 Nov 2003 00:55:59 GMT

The Admin Assistant is a graphical, Web-based utility. The Admin Assistant allows users to configure client and server components, and it allows users to create ODBC Data Sources. This presentation teaches users how to configure Admin Assistant port usage, reset authentication parameters, and change logging behavior.

Recommended Screen Resolution: 640x480