There are some examples of PHP in the test and examples subdirectories
of the PHP distribution.

There are also some examples for Perl in the Perl distribution.

Rexx/SQL and mxODBC also both contain test and example code.

OpenVMS note
============

If you get an error such as:

-SYSTEM-F-SHRIDMISMAT, ident mismatch with shareable image

when running the demo program, run the build.com command file to
rebuild it.

demo
====

The demo.c program is a live demo which connects to demo.easysoft.com
and retrieves data from MS SQLServer through the ODBC-ODBC Bridge.
No data is transmitted to Easysoft and the source is provided as an
example as so you can see what it does. We suggest you build and run
this demonstration if you have a connection to the internet as it
verifies that the client is installed correctly.

test_ini_dsns
=============

The small program uses an extra function in the OOB client shared object
to enumerate the data source names in the odbc.ini file. For each data source
found it attempts a connection and at the end of the list of DSNs it shows
a table of those which are OK and those which failed.

This example is not appropriate to the Windows operating system.

execute.html/execute.phtml/execute.phps
=======================================

execute.html is a small piece of HTML which allows the entry of some
SQL into a form which is posted to execute.phtml (HTML/PHP) where the
query is executed and the results sent back to the web server.  Copy
these files in to a directory where Apache/PHP may find them and
create an odbc.ini file like the one in this directory but which
points to a machine where the OOB Server is running. You can then
execute simple queries from the web form.

perl_e1.pl
==========

Perl script which creates a table inserts rows and then retreives the
rows back from the table. You must define the environment variables
DBI_DSN as the DBI data source (e.g. 'dbi:ODBC:example' and possibly
DBI_USER and DBI_PASS if the datasource requires a username and
password.

This script has been run from UNIX to NT SQLServer and NT Access through
the ODBC-ODBC Bridge.

perl_e2.pl
==========

Perl script which creates a table called oob_example and inserts rows
read from the file perl_data.dat". You must define the environment
variables DBI_DSN as the DBI data source (e.g. 'dbi:ODBC:example' and
possibly DBI_USER and DBI_PASS if the datasource requires a username
and password.

This script has been run from UNIX to NT SQLServer and NT Access
through the ODBC-ODBC Bridge.

blob
====

Consists of the files blob.c, helper.c and helper.h. This program can
be built with the Makefile in the same directory. It connects to the
datasource specified as the first parameter, creates a table, inserts
the easycd.jpg into it, retrieves the easycd.jpg from the table,
writes it out to out.jpg and finally displays it with xv. If you do not
have xv, then you can changes DISPLAY_JPG macro at the start of blob.c.

getdata
=======

A simple C program which reads stdin for a SQL and executes it for the
given data source. You will need to change the call to SQLDriverConnect
to specify a dsn before building this program.

SQLGetFunctions
===============

This program performs a thorough check of the ODBC API support in your
ODBC driver using the ODBC API SQLGetFunctions with all possible
configurations. A table is produced showing:

Version of ODBC the function was introduced
Level requirement in ODBC 2 and 3.
Standards compliance
whether your ODBC driver supports it in ODBC 2 or 3

SQLDataSources
==============

This is an example C program which returns a list of all the data
sources found by the driver or driver manager it is linked with. The
built example was linked directly with OOB so if you run it here you
will likely only see the one data source in the odbc.ini file in this
directory. However, if SQLDataSources.c is linked with the unixODBC
driver manager you will see all the data sources the driver manager
can see. To link with the driver manager examine the Makefile for your
platform to see what CFLAGS to use and issue a command like this:

cc -o SQLDataSources -I /usr/local/easysoft/unixODBC/include
	SQLDataSources.c -L /usr/local/easysoft/unixODBC/lib -lodbc

version
=======

Returns the version number of the driver.

