Introducing Actian Data Platform Connectivity
Actian Data Platform Warehouse
Server Installation
Client Installation
User Management
What is a Vnode (Virtual Node)?
Remote User Authorizations
Global and Private Definitions
Using Net
Connection to Remote Databases
Database Access Syntax--Connect to a Remote Database
Dynamic Vnode Specification--Connect to Remote Database
Using the SQL Connect Statement with Net
User Identity on Remote Instance
Verify Your Identity
Troubleshooting Connectivity
How Connection Between the Application and Warehouse 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
Errors When Using SSO with JDBC
Creating Server Connection Definitions (Vnodes)
Server Connection Definitions (Virtual Nodes)
Tools for Defining Vnodes
Naming Rules for Vnodes
Connection Data
Network Address Format
Simple and Advanced Vnodes
Advanced Vnode Parameters
Multiple Connection Data Entries
Additional Remote User Authorization
Vnode Attributes Configuration
Vnode Attribute Names and Values
Maintaining Connectivity
Starting the Communications Server
Inbound and Outbound Session Limits
How You Set Inbound and Outbound Session Limits
Default Remote Nodes
How You Set Default Remote Nodes
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
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
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
Ingres Super Users
DBMS Passwords
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
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
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
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 Environments
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
Connecting from Python
Understanding JDBC Connectivity
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
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
.NET Data Provider
.NET Data Provider Architecture
Data Provider Data Flow
Data Provider 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 Ingres 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
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
Integration with Visual Studio
Install the Data Provider into the Toolbox
Start the Ingres Data Adapter Configuration Wizard
Configure a Connection
Design a Query Using the Query Builder
Server Explorer Integration
Application Configuration File--Troubleshoot Applications
Obtain File Version of the Data Provider
Using Utilities
Netutil (Net Management Utility)
Netutil Startup Screen
Virtual Node Name Table in Netutil
Naming Rules for Vnodes
Login and Password Data Table in Netutil
Global and Private Definitions
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
-u user
-u user
-file filename
-file-
-vnode vnode
Input Control File
Invariant Fields
Wildcards
Create Function--Create a Remote User Authorization
type
vnode
login
password
Destroy Function--Destroy a Remote User Authorization
type
vnode
Show Function--Display Remote User Authorizations
type
vnode
Create Function--Define an Installation Password for the Local Instance
local_vnode
password
Create Function--Create a Connection Data Entry
type
vnode
network_address
protocol
listen_address
Destroy Function--Destroy a Connection Data Entry
type
vnode
network_address
protocol
listen_address
Show Function--Display Connection Data Entries
type
vnode
network_address
protocol
listen_address
Stop and Quiesce Commands--Stop or Quiesce One or More Communications Servers
server_id
Network Utility (ingnet)
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
Introducing Actian Data Platform Connectivity
Server-related Tasks