SQL/MX Connectivity Service Manual (SQL/MX 2.x)

HP NonStop SQL/MX Connectivity Service Manual—524944-008
A-1
A
Migrating Applications from
NonStop ODBC Server
You must migrate your NonStop ODBC Server applications if you plan to take
advantage of the compiler and executor features of SQL/MX for your applications. By
migrating your applications, you also take advantage of the ODBC 3.5 compliant API
driver. Like SQL/MX (BSR X3.135-1992), ODBC/MX is based on the ISO/IEC 9075-3
standard, documented by Microsoft in the ODBC 3.5 Programmer's Guide.
•
Most ODBC applications can be seamlessly migrated from the NonStop ODBC
Server environment to the MXCS environment by duplicating the object names
from NonStop ODBC Server.
•
In some cases, minor changes are required to configure the SQL/MX environment
to match the NonStop ODBC Server environment.
This section provides two checklists that describe necessary application modifications
for migration in both the server and the client environments.
Server-Side Migration Steps
1. Install SQL/MX on the NonStop system (including MXCS). See SQL/MX
Installation and Management Guide for detailed instructions.
2. Start the MXCS service by using MXOAS. For detailed information, see Starting
the MXCS Service on page 2-4.
Topic Page
Server-Side Migration Steps A-1
Server: Duplicating NonStop ODBC Server Logical
Database Object Names
A-2
Server: Migrating NonStop ODBC Server
Configuration Settings
A-5
Server: Preserving User Alias Settings A-9
Client-Side Migration Steps A-10
Client: Modifying Applications A-10
Features Not Supported A-14
NonStop ODBC Server Migration Example A-15