APPXODBCServer < Main

---+ APPX/ODBC Server
---++++ APPX/ODBC Revised for APPX Release 5.0
<p align="left">There have been significant changes in the installation and operation of APPX/ODBC, effective with the release of APPX 5.0.2. Please refer to <a target="_blank" href="../../view/Main/APPXODBCInstallationInstructions">this wiki page</a> for installation details.</p> <p align="left">-------------------------------------------------------------------------------------</p>
---+++ THE FOLLOWING INSTRUCTIONS APPLY TO APPX/ODBC IN RELEASE 4.x ONLY.
---++++ Accessing APPX data from non-APPX ODBC Clients

APPX/ODBC Server allows Windows application clients (such as DI-Diver, Excel, Access, and Crystal Reports) to view and operate upon !AppxIO datafiles. APPX/ODBC Server is a standard feature of APPX. No additional license fees are required to use it. _(If you're interested in using APPX to access data stored in a non-APPX data formats, such as SQL-Server or MS-Access' Jet database, see_ [[http://wiki.appx.com/wiki/bin/view/Main/UsingTheAPPXtoODBCConnection][ _APPX/ODBC Connection Instructions_ ]]<em>.)</em>

APPX data can be stored on a local PC, or remotely on an NT or UNIX server using [[APPXNet][APPX/Net]] connecting to an [[APPXClientServer][APPX/Server]]. With APPX/ODBC Server, data is accessed by other PC applications directly from APPX databases, without time-consuming transfer processes.
---++++ Manuals

<a target="_blank" href="http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/appxodbc-manual.pdf">The !AppxODBC Manual</a> contains detailed installation, configuration, and use information for APPX/ODBC Server. The <a target="_blank" href="http://www.appx.com/ftp/appx/documents/manuals/appx/appxodbc/current/dharma-manual.pdf">Dharma Interface Manual</a> explains how our ODBC interface works and details supported SQL statements and syntax.
---++++ Other APPX/ODBC Documents

[[InstallingAPPXODBCDriver][Installing the APPX/ODBC Driver]] contains step-by-step instructions for installing APPX/ODBC Server.

[[APPXODBCFAQ][Frequently Asked Questions]] cover a variety of topics on operation and installation.

The [[APPXODBCChecklist][APPX/ODBC Checklist]] can help if you're having difficulty accessing !AppxIO data from an external application.

[[DebuggingAPPXODBC][Debugging APPX/ODBC]] is the place to go if you've been through the above documents and you're still having problems.
---++ Comments:

_Read what other users have said about this page or add your own comments._
---

<br />%COMMENT%

-- Main.ChrisBrower - 2011-06-08
This topic: Main > WebHome > SpecialTopics > APPXODBCServer
Topic revision: r6 - 2012-06-21 - GaryRogers