SQL/MX Connectivity Service Manual for SQL/MX Release 3.1 (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Connectivity Service Manual for SQL/MX Release 3.1—663856-001
iii
A. Migrating Applications from NonStop ODBC
Server
Limitations of MFC 3-35
Troubleshooting MFC 3-35
A. Migrating Applications from NonStop ODBC Server
Server-Side Migration Steps A-1
Server: Duplicating NonStop ODBC Server Logical Database Object Names A-2
Database Object Names A-2
ANSI Names A-3
Name Mapping A-3
CREATE SQLMP ALIAS Command A-4
Using SQL Scripts to Automate Name Mapping A-4
Accessing Migrated Names A-5
Server: Migrating NonStop ODBC Server Configuration Settings A-5
Comparison of Configuration Terms A-6
Resource Governing A-7
Setting Control Statements A-7
Configuring MXCS Data Sources A-8
Setting Network Attributes A-8
Setting MXCS Service Attributes A-9
Server: Preserving User Alias Settings A-9
Client-Side Migration Steps A-10
Client: Modifying Applications A-10
ODBC API calls A-11
Modifying SQL Statements A-13
Migrating SQL Server Objects A-13
Modifying Pass-Through Commands
A-14
Features Not Supported
A-14
NonStop ODBC Server Migration Example
A-15
Server Characteristics A-15
System Catalog Names A-15
User Catalog Names
A-17
Configuration Example for the NonStop ODBC Server
A-20
Adding Aliases for System Catalog Object Names A-23
Adding Aliases for User Catalog Names
A-24
Adding User Alias Names To Safeguard
A-26
Running and Configuring MXCS
A-26
Client Data Source Configuration
A-27
B. Using Microsoft Access with ODBC/MX
SQL_ATTR_ACCESS_VERSION for Microsoft Access B-1