How To Install and Configure the Multi-Tier
Edition ODBC Drivers for OpenLink Virtuoso (macOS)
Server Components
Installation (Request Broker and
Database Agent)
There are no Server Components to Install
Configuration for Advanced Users (Click to
Show)
There are no configuration guides available
Client Components
Pre-Installation
There are no DBMS requirements associated with the Enterprise
Edition (Multi-Tier) Generic Client ODBC Drivers.
The Enterprise Edition (Multi-Tier) Generic Client ODBC Drivers
are distributed as Universal Binaries, automatically supporting all
32-bit and 64-bit clients, with both PowerPC- and Intel-based
binaries.
Installation
Download the OpenLink Generic ODBC Driver for macOS disk image
(.dmg) file.
Double-click the disk image file to open it.
Run the installer .mpkg file located inside the disk
image.
Configuration
To configure an ODBC DSN, perform the following steps:
Run the OpenLink iODBC Administrator located in the
/Applications/iODBC folder.
Click the Add button on the System DSN
tab.
Select the OpenLink Generic ODBC Driver from
the list of available drivers.
Select the Unicode version of the driver if and only if you are
working with multi-byte character sets, as unnecessary translations
can significantly affect ODBC performance.
Provide a suitable DSN name and optional description for the
Data Source.
Click the "Manual settings..." link in the
Server field and specify the host name and port on which the
OpenLink Request Broker listens. Click OK to exit
the host and port dialog.
Click Continue to proceed.
The Connection tab takes the minimum parameters required to
make a connection to the target database:
Domain - The value must match a [Domain
Alias], which is contained in the Server's Session Rules
Book.
Name - May take several settings, depending on
the Domain (e.g., database name, JDBC driver classname, Oracle SID,
etc.).
Review Complete Settings and Usage for Connect Options.
Click Continue to proceed.
On the Connection tab, input the following:
Username - A valid database uid.
Password - A valid database password.
Click Continue.
The Options tab contains settings that are not required for a
basic connection:
Read Only connection - Specifies whether the
connection is "Read-only." Make sure the checkbox is unchecked to
request a "Read/Write" connection.
Defer fetching of long data - Defers fetching
of LONG (BINARY, BLOB, etc.) data unless explicitly requested in a
query.
Disable interactive login - Suppresses the
ODBC "Username" and "Password" login dialog boxes when interacting
with your ODBC DSN from within an ODBC compliant application.
Multiple Active Statements Emulation - Enables
the use of Multiple Active statements in an ODBC application even
if the underlying database does not allow this, as it is emulated
in the driver.
Row Buffer Size - This attribute specifies the
number of records to be transported over the network in a single
network hop. Values can range from 1 to 99.
Click Continue.
Click on the 'Test Data Source button to make
a connection to the database and verify Client-to-Broker
connectivity.
This document is empty and basically useless. It is generated by a web service that can make some statements in HTML+Microdata format.
This time the service made zero such statements, sorry.