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
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
libopendbx-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
