artefaktur
software engineer &        architecture

 
 
 
 

ACDK SQL Installation

| Installation | Types | Basic Operations | Prepared Statements | Stored Procedures | Database information |

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 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.

 Test your Database connection


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.


 
Last modified 2005-05-08 22:31 by SYSTEM By Artefaktur, Ing. Bureau Kommer