3503282 - How to use ODBC FileDSN parameter on Unix/Linux -SAP IQ

For a specific application requirement, ODBC source full path should be specified.

Application is not allowed to update .odbc.ini or ODBCINI environment variable.

How to use FileDataSourceName (FileDSN) ODBC connection parameter on Linux?

When using FileDSN ODBC parameter , connection fails.

In  <full_path>/dsn.ini

####
[mydsn]

Debug=Yes
driver=<IQ_Client_HOME>/IQ-16_1/lib64/libdbodbc17.so
uid=dba
pwd=******
ServerName = MyIQsrv_iqdemo
CommLinks=tcpip{port=2642}
DBN=iqdemo

----

if both FileDSN and DSN are specified:

dbisql -c "FileDSN=<full_path>/dsn.ini;d;DSN=mydsn" -nogui
Could not connect to the database.
Parse error: Cannot find .ini file

If only FfileDSN is specified :

dbisql -c "FfileDSN=<full_path>/dsn.ini" -nogui

Could not connect to the database.
Invalid user ID or password
SQLCODE=-103, ODBC 3 State="28000"

• SAP IQ server 
• SAP IQ ODBC client
• Unix/Linux

ODBCHOME, sybase, dbping , KBA , BC-SYB-IQ , Sybase IQ , Problem