ACDK SQL Installation

How to install acdk_sql_odbc.

Content of this chapter:

   General Installation
   ACDK SQL ODBC Installation
     Windows Platform
     Unix (Linux, Solaris, FreeBSD)
   Test your Database connection

General Installation

Please refer to

Installation for general installation notice for ACDK.

ACDK SQL ODBC Installation

To make use of acdk_sql_odbc an ODBC driver for your database has to be installed.

Windows Platform

Use the ODBC Datasource configuration provided by the operation system to configure an ODBC data source.
Currently acdk_sql_odbc is tested with

MS SQL 2000
Oracle 9
MS Access

Unix (Linux, Solaris, FreeBSD)

The acdk::sql::odbc driver uses the free unixODBC driver kit.
unixODBC-1.8.8 or newer (Linux & Solaris)

http://www.unixodbc.org/.

Make and install this package.

Currently acdk_sql_odbc is tested with

mySQL
PostgreSQL (the stored procedure tests failes, because PostgreSQL has a different syntax)
Informix
Oracle.

The best way is just to run the acdk_sql_Test unit test.

Create a database, f.e. named acdk and grant all rights to create tables, stored procedures and so on to you an user.

Configure a ODBC datasource with ODBCConfig (unix) or the Datasource in system control (Windows) named f.e. also acdk.

Before running you have to ajust your database connection values in the configuration file cfg/tests/acdk/sql/odbc/Connection.properties
After ajust these values, compile and run the executable.
If all tests passes and no errors are displayed, the database connection should be OK.