Tutorial: Using Metrowerks CodeWarrior and ODBC with Adaptive Server Anywhere 9.0.1 on Mac OS X

Overview

This tutorial helps you create a sample Cocoa application with Metrowerks CodeWarrior on Mac OS X that queries the contact table within the Adaptive Server Anywhere sample database (asademo.db). The application provides the ability move through the contact table with a bi-directional cursor and save changes to Street and Zip data.

The document does not attempt to assist you with coding with ODBC or with coding in Objective-C, C, or C++; there are many resources available to assist you with these topics on the web. Instead, the document assists you in building a Code Warrior project by putting together the required components within the IDE.

Requirements

• SQL Anywhere Studio 9.0.1 for Mac OS X, or later
• Mac OS X 10.3, or later
• CodeWarrior 8.0 or later
• ODBC Driver Manager

Download the whitepaper here.

Contents

 Overview
 Requirements
 Setting up the ODBC environment
 Creating a new project
    Adding code to the project
 Adding files to the project
 Configuring the target
    Setting the prefix.h file
    Adding search/access paths
    Adding the deployment/runtime environment variables
    Adding the ODBC library to the project
    Copying the interface into the project
    Building and running the project
 Appendix A: odbcex.c
 Appendix B: odbcex.h
 Appendix C: ContactController.m
 Appendix D: ContactController.h
 Appendix E: example.h
 Appendix F: Sample odbc.ini and odbcinst.ini
 Appendix G: environment.plist
 Legal Notice
    Contact Us

Download the whitepaper here.

Related Links