UDA (ODBC, JDBC, ADO.NET, OLE-DB, XMLA)

Site Map

Site

• High-Performance Data Access Drivers for ODBC, JDBC, ADO.NET, and OLE DB

  In today's knowledge economy your ability to exploit data ultimately determines success. Thus, the technology that impacts your ability to store, access, and disseminate data across the enterprise is of ever-increasing value.
• Open Database Connectivity (ODBC)
• Single-Tier ODBC Drivers
• Microsoft SQL Server Single-Tier ODBC Driver
• Oracle Single-Tier ODBC Driver
• DB2 Single-Tier ODBC Driver
• Progress Single-Tier ODBC Driver
• Informix Single-Tier ODBC Driver
• Ingres Single-Tier ODBC Driver
• Sybase Single-Tier ODBC Driver
• MySQL Single-Tier ODBC Driver
• PostgreSQL Single-Tier ODBC Driver
• ODBC Single-Tier ODBC Driver
• JDBC Single-Tier ODBC Driver
• Multi-Tier ODBC Drivers
• Microsoft SQL Server Multi-Tier ODBC Driver
• Oracle Multi-Tier ODBC Driver
• DB2 Multi-Tier ODBC Driver
• Progress Multi-Tier ODBC Driver
• Informix Multi-Tier ODBC Driver
• Ingres Multi-Tier ODBC Driver
• Sybase Multi-Tier ODBC Driver
• Postgres Multi-Tier ODBC Driver
• Postgres Multi-Tier ODBC Driver
• Multi-Tier ODBC Bridge Driver
• JDBC Multi-Tier ODBC Driver
• Data Access Proxy Server
• Express Edition Drivers
• OpenLink ODBC Driver for Microsoft SQL Server (Express Edition)
• OpenLink ODBC Driver for Oracle (Express Edition)
• OpenLink ODBC Driver for DB2 (Express Edition)
• OpenLink ODBC Driver for Informix (Express Edition)
• OpenLink ODBC Driver for Ingres (Express Edition)
• OpenLink ODBC Driver for Sybase (Express Edition)
• OpenLink ODBC Driver for MySQL (Express Edition)
• OpenLink ODBC Driver for PostgreSQL (Express Edition)
• OpenLink ODBC Driver for Firebird (Express Edition)
• Java Database Connectivity (JDBC)
• Single-Tier JDBC Drivers
• JDBC-ODBC Single-Tier ODBC Driver
• Multi-Tier JDBC Drivers
• Microsoft SQL Server Multi-Tier JDBC Driver
• Oracle Multi-Tier JDBC Driver
• DB2 Multi-Tier JDBC Driver
• Progress Multi-Tier JDBC Driver
• Informix Multi-Tier JDBC Driver
• Ingres Multi-Tier JDBC Driver
• Sybase Multi-Tier JDBC Driver
• MySQL Multi-Tier JDBC Driver
• Postgres Multi-Tier JDBC Driver
• ODBC Multi-Tier JDBC Driver
• JDBC Drivers for JDBC
• OLE-DB Data Providers
• Single-Tier OLE-DB Drivers
• OLE DB to ODBC Provider
• ADO.Net Data Provider
• Single-Tier ADO.Net Drivers
• Microsoft SQL Server Single-Tier .Net Provider
• Sybase Single-Tier .Net Provider
• ODBC .Net Data Provider
• Multi-Tier ADO.Net Drivers
• .NET Data Providers for Microsoft SQL Server
• Oracle Multi-Tier .Net Provider
• DB2 Multi-Tier .Net Provider
• Progress Multi-Tier .Net Provider
• Informix Multi-Tier .Net Provider
• Ingres Multi-Tier .Net Provider
• .NET Data Providers for Sybase
• MySQL Multi-Tier .Net Provider
• Postgres Multi-Tier .Net Provider
• .NET Data Providers for ODBC
• .NET Data Providers for JDBC

Sales Information

• Product Licensing Model Descriptions

Documentation

• ASNPRINT Will Not Read my License
• Can I Install New Software atop Existing Software
• Can I mix and match client and server components from different OpenLink versions?
• Can I run 32Bit software on a 64Bit operating system?
• Can I run 64Bit software on a 32Bit operating system?
• Can I run multiple versions at the same time?
• I can't download software to the appropriate machine. What do I do?
• What can I do, if I can't solve the problem?
• I can't set my OpenLink variables. What do I do?
• My Request Broker shuts itself down. What do I do?
• I can't start my Admin Assistant. What do I do?
• I can't start my Request Broker. What do I do?
• I can't shutdown my Admin Assistant. What do I do?
• I can't shutdown my Request Broker. What do I do?
• Can OpenLink provide ftp access to the downloads files?
• Can OpenLink provide installation files on CD?
• Can users install on top of existing OpenLink software installations?
• Can users manually extract and install the software?
• Components are missing after installation. What do I do?
• Does OpenLink Load Share for Active-Active Clusters?
• Does OpenLink produce custom software for evaluators?
• Does OpenLink provide data migration facilities?
• Does OpenLink function in Fail-over Cluster environments?
• Does OpenLink work with Oracle Heterogeneous Services?
• Does OpenLink work with SQLServer Linked Servers?
• Does OpenLink work with the DTS Wizard?
• I think I have OpenLink Software. How can I tell?
• Do I need to configure my environment to support my JDBC connections?
• Do I need to configure my environment to support ODBC-ODBC Bridge connectivity?
• Do I need OpenLink's Universal Data Access Drivers?
• Do users need to employ special configuration to operate in a firewalled environment?
• Do you have 16Bit drivers?
• Can you explain OpenLink's installation file naming conventions?
• Heavy load causes my ODBC connections to fail. What do I do?
• How can I bench-test OpenLink drivers?
• How can I detect bottlenecks caused by OpenLink drivers?
• How can I determine which ports the Multi-Tier Request Broker uses?
• How can I assess my data access needs?
• How can I prevent performance problems?
• How can I prevent stability problems?
• How can I tell if a license is or is not corrupt?
• How can I tell if OpenLink produces software for a particular operating system or database?
• How can I tell what version I have?
• How do I configure Multi-Tier drivers, after I've installed them?
• How do I configure Single-Tier drivers, after I've installed them?
• How does clustering affect licensing?
• What should I do if I cannot start the Multi-Tier Request Broker?
• How do I assist, when a user cannot set environment variables?
• How do I configure an JDBC-ODBC Bridge connection?
• How do I configure an ODBC-JDBC Bridge connection?
• How do I configure an ODBC-ODBC Bridge connection?
• How do I create a Data Source Name?
• How do I create a ZeroConfig DSN?
• How do I get a commercial license?
• How do I get an evaluation license file?
• How do I install your products?
• How do I interpret Admin Assistant Logs?
• How do I interpret Classpaths?
• How do I interpret Database Agent Version Strings?
• How do I interpret Database Native Error Logs?
• How do I interpret Database .profiles?
• How do I interpret DBMS Versions?
• How do I interpret Installation Shell Scripts?
• How do I interpret License Files?
• How do I interpret Name of .taz files?
• How do I interpret openlink.ini Files?
• How do I interpret Operating System Patch Levels?
• How do I interpret Output of java commands?
• How do I interpret Output of oplshut command?
• How do I interpret Output of set?
• How do I interpret Re-link Scripts?
• How do I interpret Request Broker Logs?
• How do I interpret Request Broker Version Strings?
• How do interpret udbc.ini Files?
• How do I test my JDBC connection URL?
• How do I troubleshoot a failed JDBC-ODBC Bridge connection?
• How do I troubleshoot a failed ODBC-JDBC Bridge connection?
• How do I troubleshoot a failed ODBC-ODBC Bridge connection?
• How do I uninstall existing OpenLink software?
• How do users configure the odbc.ini file?
• How do users configure the odbcinst.ini file?
• How do users configure the openlink.ini file?
• How do users configure the oplrqb.ini file?
• How do users configure the udbc.ini file?
• How do users create Data Source Names?
• How do users obtain licenses?
• How do users start the Multi-Tier Request Broker?
• How do users uninstall OpenLink software?
• How do your drivers work?
• Do I use ASCII or binary for ftp transfer?
• What do I do with .bin/.dmg/.hqx/.tar/.taz/.zip files?
• I do not know the correct values for my Multi-Tier DSN. What do I do?
• Is OpenLink Support Staff responsible for all user problems?
• I suspect that my user is experiencing port or networking problems. What do I do?
• My applications fail to connect, after I upgraded my 1.x/3.x drivers to 4.x/5.x drivers. What do I do?
• My Broker shuts down intermittently. What do I do?
• My drivers occasionally fail to disconnect. What do I do?
• My drivers produce intermittent core dumps. What do I do?
• My drivers produce intermittent protrace files. What do I do?
• My existing license key expired. What do I do?
• My Multi-Tier DSN fails to connect. What do I do?
• My Multi-Tier DSN fails to disconnect. What do I do?
• My ODBC connectivity suddenly stopped working altogether. What do I do?
• My Single-Tier DSN fails to connect. What do I do?
• My Single-Tier DSN fails to disconnect. What do I do?
• My database version is newer than the version, which OpenLink supports. Can I use your software?
• My operating system version is newer than the version, which OpenLink supports. Can I use your software?
• What happened to OpenLink's non-expiring temporary licenses?
• What do I do, if I can't find suitable software for a potential evaluator?
• My database version is older than the version, which OpenLink supports. Can I use your software?
• My operating system version is older than the version, which OpenLink supports. Can I use your software?
• What's the difference between software from OpenLink Software and iODBC.org?
• The installation process hangs without an error. What do I do?
• The installation process produces errors. What do I do?
• Can you explain OpenLink's UDA component naming conventions?
• Your installer doesn't work. What do I do?
• What is OpenLink's licensing model?
• What do I tell someone who can't download the software from the OpenLink site?
• What are the differences among User, System, and File DSNs??
• What are your prerequisites and system requirements?
• What can we do to assist users who have lost their licenses?
• What configuration files are used by Multi-Tier drivers?
• What configuration files are used by Single-Tier drivers?
• What does Count Stored Procedure Parameters in SQLProcedures do?
• What does Custom Catalog Views do?
• What does Deadlock Timeout do?
• What does Default UserID do?
• What does Disable AutoCommit do?
• What does Disable Interactive Login do?
• What does Disable Rowset Size Limit do?
• What does Dynamic Cursor Sensitivity do?
• What does Enable Logging do?
• What does Enable Microsoft Jet Engine Options do?
• What does Expression Precision do?
• What does Expression Scale do?
• What does Field Size Maximum do?
• What does Field Size Minimum do?
• What does Force Online Database do?
• What does Hide Login Dialog do?
• What does Initial SQL do?
• What does Log File do?
• What does Max Long Data Length do?
• What does MaxRows Override do?
• What does Multiplex sessions do?
• What does No Quoted Identifiers do?
• What does OCIPrefetchMemory do?
• What does OCIPrefetchRows do?
• What does Packet Size do
• What does Prepare Method do
• What does Remote Database Alias refer to
• What does Rowbuffer Size do
• What does Show Remarks do
• What does Space Pad Character columns do
• What does SQL_DBMS_NAME do
• What does USE ANSI nulls, padding and warnings do
• What does Use Extended Fetch do?
• What does User's own tables first in SQLTables mean
• What does Use SPACE for SQL_IDENTIFIER_QUOTE_CHAR do
• What do I assist a user who does not know what values to pass to his or her variables?
• Trouble-shooting register a product with a temporary or commercial license
• What do I do if my JDBC connections fail?
• What do I do with the DSNs that I create?
• What do I do with the license file?
• What do I need to establish a Multi-Tier JDBC connection?
• What do I need to establish a Single-Tier JDBC connection?
• What do I need to test the JDBC-ODBC Bridge?
• What do I need to test the ODBC-JDBC Bridge?
• What do I need to test the ODBC-ODBC Bridge?
• What do I pass in a Multi-Tier JDBC connection URL?
• What do I pass in a Single-Tier JDBC connection URL?
• What do I tell users who want new temporary licenses?
• What do users need to do to configure their Multi-Tier drivers?
• What do users need to do to configure their Single-Tier drivers?
• What do your drivers do?
• What environment variables need to be set on Unix systems
• What environment variables need to be set on Windows system
• What sort of evidence is require for a support case
• What factors contribute to performance problems
• What factors contribute to stability problems
• What happened to the jdbc, jodbc_sv, and judbc_sv agents
• What is a concurrent connection
• What is a concurrent user
• What is ASNPRINT.exe
• What are the "ODBC Lite" and "Generic ODBC" drivers
• What Is The JDBC-ODBC Bridge
• What is the ODBC-JDBC Bridge
• What is the ODBC-ODBC Bridge
• What is the odbc.ini file?
• What is the odbcinst.ini file
• What is the openlink.ini file
• What is the oplrqb.ini file
• What is the proper way to perform an upgrade
• What is the udbc.ini file
• What is ZeroConfig
• What JDBC connection formats do Multi-Tier drivers support
• What JDBC connection formats do Single-Tier drivers support
• What network protocols do you support
• What ports do users need to open on their firewalls to use OpenLink software
• What resources can I use to solve Support cases
• What services do users start to use OpenLink drivers
• What steps should I take to debug my cases
• What types of problems do consultants debug
• What values do I pass for my OpenLink environment variables?
• What Values Do Multi-Tier Users Need To Pass In Their Data-Sources?
• What Values Do Single-Tier Users Need To Pass In Their DataSources?
• What values must I pass in my Multi-Tier DSN
• What Values Must I Pass In My Single-Tier DSN
• Why Do Some Users Require Permanent Licenses Where as Some Users Do Not
• Why Do Some Users Require Temporary Licenses Where as Some Users Do Not
• Why I Cannot Download From Site
• Why should I upgrade
• UDA ADO.Net Data Provider Technical Whitepaper

  As a core element in the ADO.NET architecture, your choice of data provider is crucial. The aim of this White Paper is to describe OpenLink .NET providers and highlight key considerations you should bear in mind when selecting a data provider.
• Create SQL Server Linked Servers with OpenLink ODBC Drivers
• Link iODBC and ODBC Applications on Mac OS HOW-TO

  This document provides information on linking your ODBC Applications with iODBC on Mac OS systems. iODBC is an alternative solution for developing ODBC components and applications for non-Windows systems (Mac OS Classic, Mac OS X, Linux and Unix platforms).
• Migration of ODBC drivers to Mac OS X

  This document provides the necessary information required for the migration and integration of an ODBC driver on Mac OS X. iODBC is an alternative ODBC Driver Manager solution for developing ODBC drivers and applications for non-Windows systems (e.g. Mac OS Classic, Mac OS X, Linux and Unix).
• Configuring the OpenLink Proxy Agent to access content behind your firewall

  This document explains how to set up and use the OpenLink Multi-Tier, configuring the OpenLink Proxy to access data behind your firewall. To get the most from this paper, you should have a basic understanding of TCP/IP and how the OpenLink Multi-Tier drivers work.
• High-Performance Data Access Drivers for ODBC, JDBC, ADO.NET, and OLE DB

  In today's knowledge economy your ability to exploit data ultimately determines success. Thus, the technology that impacts your ability to store, access, and disseminate data across the enterprise is of ever-increasing value.