Analytics Software

How to configure an ODBC connection to a CSV file on Linux for access from the BI Server Repository physical layer

I am migrating a working windows OBIEE installation to Linux and can not seem to connect to csv files on Linux (from th BI server also running on the same Linux machine).

I am using SUse Linux Enterprise server / 10 (Slash 10) standard odbc drivers

My odbc ini file entries are:

[ODBC]
Trace=0
TraceFile=odbctrace.out
TraceDll=/app/oracle/product/10.1.3/OracleBI/odbc/lib/odbctrac.so
InstallDir=/app/oracle/product/10.1.3/OracleBI/odbc
UseCursorLib=0
IANAAppCodePage=4

[ODBC Data Sources]
AnalyticsWeb=Oracle BI Server
Cluster=Oracle BI Server
SSL_Sample=Oracle BI Server
idcbicsvfiles=Odbc Text driver

[idcbicsvfiles]
Description = Odbc Text driver
Driver = Odbc Text driver
Directory = /data/oracle/OracleBIData/idc
#ReadOnly = No
#CaseSensitive = No
#Catalog = No
ColumnSeperator = ,
#Trace = 1
#Tracefile =/data/oracle/OracleBIData/odbctrace.txt
#Username = oracle
#Password = ''


[AnalyticsWeb]
Driver=/app/oracle/product/10.1.3/OracleBI/server/Bin/libnqsodbc.so
Description=Oracle BI Server
ServerMachine=local
Repository=
Catalog=
UID=
PWD=
Port=9703

The csv files I want to use are in the directory /data/oracle/OracleBIData/idc to which I have set up a working and checked connection ([idcbicsvfiles]) on the linux machine itself.

The error message I get when I select view data in the physcial layer is:

[NQODBC][SQL_STATE: HY000][nQSError: 10058] A general error has occurred.
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 16023] The ODBC function has returned ans error. The database may not be available, or the network may be down.

Please can anybody give me a clue on how to get this working e.g. a working odbc.ini file from your own installation (and/or a tip for the odbc driver choice/configuration)

P.S. I know this is not supported by Oracle but can not imagine, that nobody is using this.