/////////////////////////////////////////////////////////////////////////
//                                                                     //
//                  Northgate Information Solutions                    //
//                                                                     //
//                           RealSQL-ODBC                              //
//                                                                     //
//                   Microsoft ODBC Access to Reality                  //
//                                                                     //
/////////////////////////////////////////////////////////////////////////


The RealSQL-ODBC Driver enables access via a TPC/IP network to data 
resident on a Reality database from an ODBC-Compliant Application.

Components
==========

> rlxsql32.dll     - The driver.
> rlxstp32.dll     - The driver setup DLL.
> rlxdld32.dld     - The Auto-downloader.
> RealDbTest.exe   - Program to test an ODBC connection.
> RealDbTest.c     - Source for above program.
> readme.txt       - This README file.
> _unodbc.log      - Log file required for an uninstall operation.
> Uninst.isu       - InstallShield Uninstall log file.

Prerequisites
=============

You must have PCSNI 2.2 Rev C (or later) installed. 
A PCSNI system entry, which points to a Reality database. 
System entries are defined in the file "WINDIR\winsni.ini" 
where "WINDIR" is the Windows root directory.
For example...

[DBASE90]
protocol=DDATCP
host=magpie
dbase=live_dbase
port=1203

Version Information
===================

Version		Description
-------		-----------
2.4		Threadsafe access, with no thread affinity.
		Supports COM+ Transaction Services (MTS)
		
2.5		Support Binary Data types, and enhanced SQL NULL handling


Setup Instructions
==================

After installing the driver you can create a Reality Data Source using 
the 'ODBC Data Source Administrator', which may be launched from the
setup program or directly from the system control panel.

RealDbTest
==========

This is a sample 'C' program (unsupported) designed to test an ODBC 
connection to a Reality database. SQL statements are executed and the 
results displayed.

To establish a connection there must be a valid PCSNI system entry 
pointing to a Reality database, as defined above.

The user must also supply either...

(a) A USER or SYSTEM DSN (Data Source Name).
(b) A CONSTR (ConnectString).

Only one type maybe supplied.

For example, connecting using a DSN ...

 realdbtest -d"DB9.0" -s"SELECT * FROM EMP"

Connecting using a CONSTR ...

 realdbtest -c"System=LIVE_DBASE;Account=LIVE-DATA;UID=tom;PWD=1q4ftH" -s"SELECT * FROM EMP"

Notes
^^^^^
File DSN's are not recognised by the RealDbTest program. Using the CONSTR allows
a connection to be tested without having an ODBC Data Source (DSN) defined.