[opendbx] Was send here from the Pharo Smallltalk mailing list

[Friedrich D. <fr...@q-...>]

Someone mentioned there that one can use OpenDBX via ODBC to access an
ODBC Data source. 

Well may be. I manage to get the 1.4.6 Version compiled and installed on
my machine. Unfortunatly while trying to connec to the Data source (an
mdb file via the odbc drivers from easysoft I got this error:


./odbxplustest -b odbc -d testDB -v

Parameter:
  backend=odbc
  database=testDB
  runs=1
  verbose=1

1. Run:
  Conn::Conn()
  Conn::getCapability()
    ODBX_CAP_BASIC: 1
    ODBX_CAP_LO: 0
  Conn::{get/set}Option()
    ODBX_OPT_API_VERSION: 10200 
    ODBX_OPT_THREAD_SAFE: 1 
    ODBX_OPT_TLS: 0 
    ODBX_OPT_CONNECT_TIMEOUT: 1 (using)
    ODBX_OPT_MULTI_STATEMENTS: 0 
    ODBX_OPT_PAGED_RESULTS: 0 
    ODBX_OPT_COMPRESS: 0 
  Conn::bind()
Caught exception: [unixODBC][Driver Manager]Data source name not found, and no default driver specified


I'm using this odbcint.ini
[Easysoft ODBC-ACCESS]
Description=Easysoft ODBC-Access Driver
Driver=/usr/local/easysoft/access/lib/libesmdb.so
Setup=/usr/local/easysoft/access/lib/libesmdbS.so
Threading=0
FileUsage=1
DontDLClose=1
UsageCount=3

and this odbc.ini
[testDB]
Driver          = Easysoft ODBC-ACCESS
Description     = Easysoft MDB ODBC Driver
mdbfile         = /home/frido/tmp/mandan01.mdb


So why isn't it finding the ODBC-Access driver. 

The output of odbcinst -j is
unixODBC 2.3.0
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/frido/.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

I can not see any typo and any other reason why this works "native" but
not via libopendbx.

Any idea what I'm doing wrong?

Regards
Friedrich