• Introducing Actian Ingres Connectivity
  • In This Guide
  • Connectivity Solutions Not in This Guide
  • Basic Networking Concepts
  • Actian Ingres Components and Tools
    • Actian Ingres Instance
      • Server Installation
      • Client Installation
  • System-specific Text in This Guide
  • Terminology Used in This Guide
  • Syntax Conventions Used in This Guide
• Exploring Net
  • Ingres Net
    • General Communication Facility
      • Communications Server
    • Net Security
  • Installation Configurations That Require Net
  • Net and Other Ingres-related Products
    • Net and Enterprise Access and EDBC Products
    • Net and Ingres Star
    • Net Product Integration Summary
  • Benefits of Net
  • Net Concepts
    • Virtual Nodes
    • Connection Data
      • Listen Address
    • Remote User Authorizations
    • Global and Private Definitions
  • Net Management Tools
  • Net Users
    • System Administrator and Ingres Net
    • Database Administrator and Ingres Net
    • End Users and Actian Ingres Net
  • GCA Privileges
• Installing and Configuring Net
  • Net Installation Components
  • How You Prepare for Installation
    • Network Installation and Testing
      • TCP/IP Installation (Windows)
      • TCP/IP Installation (Linux)
    • Setup Parameters for Net
      • Installation Password and Remote User Authorization
      • Setup Parameters for a Server Installation
      • Setup Parameters for a Client Installation
  • How Net Setup Works on an Existing Installation
  • How Communications Are Enabled
  • How You Install Net
    • ingvalidpw Program
    • Create Password Validation Program (Linux)
  • Net Configuration Parameters--Customize Ingres Net
• Establishing Communications
  • How to Establish User Access
    • Requirements for Accessing Remote Instances
    • Requirements for Accessing Distributed Databases
  • Tools for Defining Vnodes
  • Netutil (Net Management Utility)
    • Netutil Startup Screen
    • Virtual Node Name Table in Netutil
      • Naming Rules for Vnodes
    • Login and Password Data Table in Netutil
      • Task-Specific Values for the Login/Password Data Fields
    • Connection Data Table in Netutil
      • Network Protocol Keywords
    • Other Attribute Data Table in Netutil
    • Netutil Operations
    • Prerequisites to Establish and Test a Remote Connection
    • Establish and Test a Remote Connection Using Netutil
      • Configure Vnode Attributes
    • Delete an Entry
      • Delete All Vnode Information
    • Change an Entry
      • Modify a Vnode Name
    • Define an Installation Password for the Local Instance
  • Netutil Non-Interactive Mode
    • Command Line Flags in Netutil Non-interactive Mode
      • Input Control File
      • Invariant Fields
      • Wildcards
    • Create Function--Create a Remote User Authorization
    • Destroy Function--Destroy a Remote User Authorization
    • Show Function--Display Remote User Authorizations
    • Create Function--Define an Installation Password for the Local Instance
    • Create Function--Create a Connection Data Entry
    • Destroy Function--Destroy a Connection Data Entry
    • Show Function--Display Connection Data Entries
    • Stop and Quiesce Commands--Stop or Quiesce One or More Communications Servers
  • Network Utility and Visual DBA
    • Virtual Nodes Toolbar
    • Simple and Advanced Vnodes
    • Advanced Vnode Parameters
      • Multiple Connection Data Entries
      • Additional Remote User Authorization
      • Vnode Attributes Configuration
    • Installation Password Definitions for the Local Instance
    • Changing Installation Passwords
    • Additional Vnode-Related Tasks
      • Refresh Vnodes
      • Opening Utility Windows
    • Server-related Tasks
• Using Net
  • Connection to Remote Databases
    • Database Access Syntax--Connect to Remote Database
      • Dynamic Vnode Specification--Connect to Remote Database
      • Server Classes
    • Use of the SQL CONNECT Statement with Net
    • Using a Local Communications Server for Remote Connections
  • Commands and Net
  • User Identity on Remote Instance
    • -u Command Flag--Impersonate User
    • Verify Your Identity
• Maintaining Connectivity
  • Start Communications Server
  • Stop Communications Server
  • Network Server Control Screen in Netutil
  • Stop or Quiesce a Communications Server Using Netutil
  • Inbound and Outbound Session Limits
    • How You Set Inbound and Outbound Session Limits
  • Logging Levels
    • How You Change the Logging Level
  • How You Direct Logging Output to a File
  • GCF Server Management Using iimonitor
  • Default Remote Nodes
    • How You Set Default Remote Nodes
  • Start Data Access Server (DAS)
  • Stop Data Access Server (DAS)
• Troubleshooting Connectivity
  • How Connection Between the Application and DBMS Server Is Established
  • Where Ingres Net Information Is Stored
    • config.dat--Store Net Configuration Values
    • Name Server Database--Store Remote Access Information
  • Causes of Connectivity Problems
  • How You Diagnose Connectivity Problems
    • General Net Installation Check
      • How You Check Net Installation on Windows
      • How You Check Net Installation on Linux
    • Connection Errors
      • Local Connection Errors
      • How You Resolve Remote Connection Errors
    • How You Resolve Net Registration Problems
    • Security and Permission Errors
      • How You Resolve Security Problems (Linux)
• Exploring Bridge
  • Ingres Bridge
    • How the Bridge Server Works
    • Tools for Configuring Bridge
    • Installation Configurations That Require Bridge
      • Sample Installation Configuration Using Bridge
  • How Bridge Is Installed
  • How Bridge Is Started
    • config.dat File--Store Bridge Configuration
    • ingstart Command--Start the Bridge Server
    • iigcb Command--Start the Bridge Server
  • How the Client Is Set Up
    • vnode Definition--Enable Client Access to Remote Servers Through Bridge
  • Bridge Server Monitoring
  • Stop the Bridge Server
  • How a Connection Is Established Through Bridge
  • Bridge Troubleshooting
  • Sample Bridge Server Configuration
• Configuring the Data Access Server
  • Data Access Server
  • Data Access Server Parameters--Configure DAS
  • How You Enable Data Access Server Tracing
    • Tracing Levels
    • Set DAS Tracing
• Understanding ODBC Connectivity
  • ODBC Driver
  • ODBC Call-level Interface
  • Unsupported ODBC Features
  • Read-Only Driver Option
  • ODBC Driver Requirements
    • ODBC Driver Manager Programs
      • UnixODBC Implementation Considerations
    • Support for Previously Released ODBC Drivers
    • ODBC Driver Names
    • Backward Compatibility Issues for ODBC DSN Definitions
    • II_ODBC_WCHAR_SIZE for Unicode Compatibility with unixODBC or DataDirect
  • Access to a Remote Instance
    • vnode Connection
    • Dynamic Vnode (Vnode-less)
    • Serverless Client
  • Configure a Data Source (Windows)
  • Configure a Data Source (Linux)
    • iiodbcadmin Utility
  • Connection String Keywords
  • ODBC CLI Implementation Considerations
    • Configuration on Linux
    • Optional Data Source Definitions
  • Supported Applications
  • ODBC Programming
    • ODBC Handles
    • How ODBC Applications Connect to a Database
    • SQLConnect()--Connect Using a Data Source Name
    • SQLDriverConnect()--Connect without Using a Data Source Name
    • Connect Using Dynamic Vnode Definitions
    • ODBC User Authentication
      • User Name and Password
      • Actian Ingres Super Users
      • Installation Passwords
      • DBMS Passwords
      • Kerberos
      • Dynamic (Run-Time) Authentication (Windows Only)
      • Specification of User Names and Passwords in ODBC
    • Query Execution
      • SQLExecDirect()--Execute Queries Directly
      • SQLPrepare() and SQLExecute()--Prepare and Execute Queries
      • Queries with Dynamic Parameters
    • Database Procedure Execution
      • Database Procedures that Return Values
      • Database Procedures with Input Parameters
      • Database Procedures with BYREF Parameters
      • Database Procedures that Return Rows
      • Batch Execution
      • Explicit Batch Execution
    • Fetched Data
      • SQLFetch()--Fetch Single Rows
      • SQLGetData() and SQLBindCol()--Bind Fetched Data
      • SQLFetchScroll()--Fetch Record Sets
      • Column-wise versus Row-wise Binding
      • SQLSetCursorName()--Declare Cursor
      • Updatable Cursors
      • Cursors versus Select Loops
      • SQLFreeStmt()--Close Fetch Loop
    • Scrollable Cursors
      • Static Scrollable Cursors
      • Keyset-driven Scrollable Cursors
      • Scrollable Cursor Programming Considerations
      • SQLFetchScroll()--Fetch from a Scrollable Cursor
      • SQLSetPos()--Scroll Cursor to Absolute Position
      • Static Scrollable Cursor Example
      • Keyset-driven Scrollable Cursor Example
    • Large Objects (Blobs) Support
      • SQLPutData()--Send Data in Segments
      • SQLGetData()--Fetch Data in Segments
    • Transactions Handling
      • SQLSetConnectAttr()--Enable Autocommit
      • Simulated Autocommit for Cursors
      • SQLSetStmtAttr()--Set Transaction Isolation Level
      • Distributed (XA) Transactions
      • Supported Data Types
    • Datetime Columns and Values
      • ODBC Support for ANSI Syntax
      • Support for Ingres Date Syntax
      • Special Date Values Meaning "TBD"
      • Default Treatment of Datetime Syntax
    • Boolean Columns
    • National Character Set (Unicode) Columns
    • GUID/UUID Columns
      • Example:
    • Metadata (Catalog) Queries
      • Error Reporting
    • Termination and Clean-up
    • ODBC CLI Connection Pooling
      • ODBC Connection Pools: Per Driver and Per Environment
      • ODBC Connection Pool Match Criteria: Strict and Relaxed
      • ODBC Connection Pool Timeout
  • Actian Ingres ODBC and Distributed Transactions (Windows)
    • How You Enable the Use of Distributed Transactions through the ODBC Driver
    • Vnode Definitions When Using Distributed Transactions through ODBC
    • Troubleshooting Distributed Transactions through ODBC
  • ODBC Trace Diagnostics
    • Standard ODBC Tracing
    • Windows Environments
    • Linux Environment
      • Ingres ODBC CLI
      • UnixODBC Driver Managers
    • ODBC Tracing on All Platforms--Internal ODBC Tracing
      • Internal versus Standard ODBC Trace Logs
    • Disable Tracing
      • How You Disable Standard Tracing
      • How You Disable Internal Tracing
• Understanding JDBC Connectivity
  • Getting Started
  • JDBC Components
    • JDBC Driver
    • JDBC Information Utility--Load the JDBC Driver
      • Driver Archive Interface
      • Set CLASSPATH Environment
  • Unsupported JDBC Features
  • JDBC Driver Interface
    • JDBC Driver and Data Source Classes
      • JDBC Driver Properties
      • Data Source Properties
      • Additional Data Source Properties
      • System Properties
      • How the Driver Is Loaded
      • DriverManager.getConnection() Method--Establish JDBC Driver Connection
      • Access to a Remote Instance
  • JDBC Implementation Considerations
    • JDBC User Authentication
    • How Transactions Are Autocommitted
      • autocommit_mode Connection Property--Set Autocommit Processing Mode
    • Cursors and Result Set Characteristics
      • Turn Off Bi-directional Updatable Scrollable Cursors
    • Cursors and Select Loops
    • Batch Statement Execution
      • Batch Statement Execution Example
    • Database Procedures
      • Named and Unnamed Parameters
      • Additional Parameter Considerations
      • Executing Procedures
    • BLOB Column Handling
      • Large Data Objects
      • LOB Data Streams
      • LOB Locators
      • Cached LOB Values
    • Datetime Columns and Values
    • National Character Set Columns
    • Using Data Compression
  • Data Type Compatibility
  • JDBC Tracing
    • Tracing Levels
    • JDBC Driver Tracing Using Java Logging Package
      • DBMS Tracing Using Java Logging Package
      • Example Logging Configuration
• Understanding .NET Data Provider Connectivity
  • Getting Started
  • .NET Data Provider
  • .NET Framework versus .NET Core
  • .NET Data Provider Architecture
    • Data Provider Data Flow
    • Data Provider NuGet versus Assembly
    • Data Provider Namespace
    • Data Retrieval Strategies
    • Connection Pooling
  • Code Access Security
  • .NET Data Provider Classes
    • IngresCommand Class
      • IngresCommand Class Declaration
      • IngresCommand Class Example
      • IngresCommand Class Properties
      • IngresCommand Class Public Methods
      • IngresCommand Class Constructors
    • Sample Program Constructed with .NET Data Provider
    • IngresCommandBuilder Class
      • IngresCommandBuilder Class Declaration
      • IngresCommandBuilder Class Properties
      • IngresCommandBuilder Class Methods
      • IngresCommandBuilder Class Constructors
    • IngresConnection Class
      • IngresConnection Class Declaration
      • IngresConnection Class Example
      • IngresConnection Class Properties
      • IngresConnection Class Public Methods
      • IngresConnection Class Events
      • IngresConnection Class Constructors
      • Connection String Keywords
      • User ID Options for the Data Provider
      • SendIngresDates Connection Keyword
      • IngresConnection.GetSchema Method
      • Enlistment in Distributed Transactions
      • System.Transactions Programming Models
    • IngresConnectionStringBuilder Class
      • IngresConnectionStringBuilder Class Declaration
      • IngresConnectionStringBuilder Class Properties
      • IngresConnectionStringBuilder Class Methods
      • IngresConnectionStringBuilder Class Constructors
    • IngresDataReader Class
      • IngresDataReader Class Declaration
      • IngresDataReader Class Example
      • IngresDataReader Class Properties
      • IngresDataReader Class Public Methods
      • GetSchemaTable Columns Returned
      • Mapping of Actian Database Native Types to .NET Types
    • IngresDataAdapter Class
      • IngresDataAdapter Class Declaration
      • IngresDataAdapter Class Example
      • IngresDataAdapter Class Properties
      • IngresDataAdapter Class Public Methods
      • IngresDataAdapter Class Events
      • IngresDataAdapter Class Constructors
      • Batch Statement Execution
    • IngresError Class
      • IngresError Class Declaration
      • IngresError Class Example
      • IngresError Class Properties
      • IngresError Class Public Methods
    • IngresErrorCollection Class
      • IngresErrorCollection Class Declaration
      • IngresErrorCollection Class Example
      • IngresErrorCollection Class Properties
      • IngresErrorCollection Class Public Methods
    • IngresException Class
      • IngresException Class Declaration
      • IngresException Class Example
      • IngresException Class Properties
      • IngresException Class Public Methods
    • IngresFactory Class
      • IngresFactory Class Declaration
      • IngresFactory Class Public Fields
      • IngresFactory Class Public Methods
    • IngresInfoMessageEventArgs Class
      • IngresInfoMessageEventArgs Class Declaration
      • IngresInfoMessageEventArgs Class Example
      • IngresInfoMessageEventArgs Class Properties
    • IngresInfoMessageEventHandler Class
      • IngresInfoMessageEventHandler Class Declaration
      • IngresInfoMessageEventHandler Class Example
    • IngresMetaDataCollectionNames Class
      • IngresMetaDataCollectionNames Class Declaration
    • IngresParameter Class
      • Positional Parameters
      • Named Parameters
      • Named Parameters Example
      • IngresParameter Class Example
      • IngresParameter Class Declaration
      • IngresParameter Class Properties
      • IngresParameter Class Public Methods
      • IngresParameter Class Constructors
    • IngresParameterCollection Class
      • IngresParameterCollection Class Declaration
      • IngresParameterCollection Class Example
      • IngresParameterCollection Class Properties
      • IngresParameterCollection Class Public Methods
    • IngresPermission Class
    • IngresRowUpdatedEventArgs Class
      • IngresRowUpdatedEventArgs Class Declaration
      • IngresRowUpdatedEventArgs Class Properties
    • IngresRowUpdatedEventHandler Class
      • IngresRowUpdatedEventHandler Class Declaration
    • IngresRowUpdatingEventArgs Class
      • IngresRowUpdatingEventArgs Class Declaration
      • IngresRowUpdatingEventArgs Class Properties
    • IngresRowUpdatingEventHandler Class
      • IngresRowUpdatingEventHandler Class Declaration
    • IngresTransaction Class
      • IngresTransaction Class Declaration
      • IngresTransaction Class Example
      • IngresTransaction Class Properties
      • IngresTransaction Class Methods
  • Data Types Mapping
    • DbType Mapping
    • Coercion of Unicode Strings
  • IngresDataReader Object--Retrieve Data from the Database
    • Build the IngresDataReader
    • IngresDataReader Methods
    • Example: Using the IngresDataReader
    • ExecuteScalar Method--Obtain a Single Value from a Database
    • GetBytes Method--Obtain BLOB Values from a Database
    • GetSchemaTable Method--Obtain Schema Information from a Database
  • ExecuteNonQuery Method--Modify and Update Database
    • IngresDataAdapter Object--Manage Data
      • IngresDataAdapter Events
  • How Database Procedures Are Called
    • Row Producing Procedures
  • Plug-ins to .NET Data Provider
    • Creating a New Plug-in
    • Install Plug-in from .NET Application
      • Custom Plugin Example – Joinop
      • Custom Plugin Example – TrimChars
  • Integration with Visual Studio
    • Install the Data Provider into the Toolbox
    • Start the Data Adapter Configuration Wizard
      • Configure a Connection
    • Design a Query Using the Query Builder
    • Server Explorer Integration
  • Application Configuration File--Troubleshoot Applications
    • Capturing DBMS Server Trace Information
  • Dotnetinfo Utility--Obtain File Version of the Data Provider
• TCP/IP Protocol
  • Listen Address Format
  • Network Address Format
  • Connection Data Entry Information
    • Windows
    • Linux
• IPv6 Configuration
  • IPv6 Configuration Overview
  • TCP/IP and Actian Ingres Communications
  • Parameters for Controlling IPv6 Support
    • II_TCPIP_VERSION Environment Variable--Specify Version of TCP/IP to Use
      • value
    • II_GC_PROT Environment Variable--Set IPC Protocol
      • protocol
    • ii.hostname.gcX.*.protocol.status Resource--Set Network Communications Protocol
      • protocol
  • Options for Disabling IPv6 Support
    • Use IPv4 Addresses Only
    • Back Out IPv6 Support
    • iicvtwintcp Command--Convert wintcp to tcp_ip Protocol Setting
      • iicvtwintcp Examples
  • IPv6 in the JDBC Driver and .NET Data Provider
  • Examples of Disabling IPv6 Support
• Third Party Connectors Certified with Actian Ingres 12.1

Introducing Actian Ingres Connectivity

Third Party Connectors Certified with Actian Ingres 12.1