Mount the installation CD-ROM for AcuXDBC.
Change to the mount directory.
./install and follow the instructions given from the command line.
Download an ODBC driver for UNIX. AcuXDBC has been tested with "unixODBC" from
www.unixodbc.org/unixODBC-2.2.11.tar.gz. 64-bit platforms require unixODBC version 2.2.12 or later.
unixODBC*.tar.gz file to a location where you have permission to create files and directories.
tar xvf unixODBC*.tar
readme file located in the directory where the package was extracted and any other
readme files with a suffix that describes your operating system (for example,
readme.aix for IBM.AIX). These directions are provided for a basic 32-bit Linux (Intel x86) installation.
install file for prerequisites and installation instructions.
configure and wait while features on your system are being checked.
make and wait for the package to be compiled.
make install to install programs, data, and documentation.
odbcinst -j to find out where your SYSTEM and USER data sources are located. Here is the location information from a Linux system.
SYSTEM DATA SOURCES:/usr/local/etc/odbc.ini
USER DATA SOURCES..:/home/techsup/.odbc.ini
Add the following to the file where your SYSTEM data sources are located (for example,
[ODBC Data Sources]
vision_sys = VORTEXodbc to VISION
Driver = /usr2/lib/acuxdbc.so
Description = VORTEXodbc to VISION
LoginID = system
/opt/acucorp/xxx/lib, create another
odbc.ini file with the following information:
rem -------------- VORTEXodbc
fetch_buffer_size 8192 --fetch buffer size (in bytes)
columns 256 -- max # of database columns
logical_cursors 1024 -- max # of logical cursors
db_cursors 64 -- max # of DB cursors
- If the information above is for use on a local machine, enter:
- If the information above is for use on a server, enter:
Set two operating environment variables called
GENESIS_HOME to the root installation directory of AcuXDBC,
/opt/acucorp/xxx/ by default. The following is an example of how to set these variables:
Note: The value of the environment variable should not have a “/” as the last character, because this can interfere with installation
and configuration scripts.
Set or modify environment variables that point to the location of the AcuXDBC executables and to tell the operating system
where to find the AcuXDBC shared libraries. On Linux, use the PATH and LD_LIBRARY_PATH variables, for example:
Modify the AcuXDBC configuration file. A sample configuration file called
acuxdbc.cfg is provided for your convenience. The configuration file must be located at
$GENESIS_HOME. There are two variables that are required:
FILE_PREFIX. Other variables may be needed depending on your situation. Below is a partial sample of
acuxdbc.cfg. showing the syntax for the two required variables. Note that this file also contains sample syntax and instructions for
all available variables. If you want to use this file, you can remove the comment indicators from any of the other variables
# The path to your system catalog directory
# The path to your data files. You must prepend the line with a semi-colon,
# use either double backslashes ("\\") or forward slashes ("/"),
# and separate your paths by semi-colons.
FILE_PREFIX, the delimiting character is a semi-colon or colon. Spaces are not supported in this AcuXDBC variable.
Verify that the AcuXDBC license file,
xvision.alc, is located in the bin directory.
Run the setup script
demo.sh located in the
Try to access a sample Vision file using a utility that came with unixODBC. To run the test, type
isql vision_sys system manager.
A successful connection looks like this:
Connected! sql-statementhelp [tablename]quit
To use the unixODBC driver, set up a Data Source Name (DSN) for the veterinary data:
Start menu, select
Programs/extend xxx/AcuXDBC/ODBC Data Source Administrator.
The ODBC Data Source Administrator appears.
User DSN tab, click
From the Create New Data Source dialog box, select
extend AcuXDBC Driver, and then click
On the AcuXDBC Setup: General Tab, complete the fields as follows:
|Data Source Name
Sample veterinary application data
||Accept the default value
Access the veterinary database from an ODBC-compliant application as described in
Working with Windows and Java Applications.