Created On:  12 June 2012

Problem:

[ISQL]ERROR: Could not SQLConnect, when using unixODBC on a Linux 64bit server with AcuXDBC.

Resolution:

To connect acuXDBC with unixODBC on a 64bit machine, you need to install unixODBC version 2.2.12 or later, at this point the version available in www.unixodbc.org is 2.3.1, install this version.

Set the following variable in your environment to compile the isql executable as 64bit object:

setenv CFLAGS -m64

or

export CFLAGS=-m64

depending upon your shell

Follow the instructions in the AcuXDBC User's Guide; Chapter 5:Installing AcuXDBC > 5.2 Installing AcuXDBC/AcuXDBC Server > 5.2.2 UNIX/Linux Installations, but you need to execute the following commands “asroot”, this is because a regular user doesn’t have permissions over the /usr/local/etc directory and the unixODBC process accesses this directory:

Type "configure" and wait while features on your system are being checked.

Type "make" and wait for the package to be compiled.

Type "make install" to install programs, data, and documentation.

Continue with the instructions in the docs.

To trace isql, add the following lines to the end of /usr/local/etc/odbcinst.ini:

[ODBC]

Trace = yes

TraceFile = /tmp/unixODBC.trc

N/A