Re: unix odbc and informix datasource problem

Hello Kate and ALL, I have similar odbc.ini and odbcinst.ini files. I am getting the same error as Kate. I have the sdk v2.9 installed. host1-d:/usr/informix/etc # isql -v asr [IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified [ISQL]ERROR: Could not SQLConnect What did you do to get around this error ? I enabled the ODBCINI env variable for the "informix" user as ODBCINI=/usr/informix/etc/odbc.ini I have pasted my odbc.ini and odbcinst.ini below, MY ODBCINST.INI [ODBC Drivers] IBM INFORMIX ODBC DRIVER=Installed \\n [Informix] Driver=/usr/informix/lib/cli/iclit09b.so #Driver=/extra/informix/lib/cli/iclit09b.so #Setup=/extra/informix/lib/cli/iclit09b.so APILevel=1 ConnectFunctions=YYY DriverODBCVer=03.51 FileUsage=0 SQLLevel=1 smProcessPerConnect=Y My ODBC.INI [asr] Driver=Informix Description=IBM INFORMIX ODBC DRIVER Database=asr LogonID=usrtest pwd=usrtest Servername=ids_server1 \\n CLIENT_LOCALE=en_us.8859-1 DB_LOCALE=en_us.8859-1TRANSLATIONDLL=/usr/informix/lib/esql/igo4a304.so \\n [ODBC] ;uncomment the below line for UNICODE connection ;UNICODE=UCS-4 \\n Trace=0 TraceFile=/tmp/odbctrace.out Any help i greatly appreciated. thanks spk kjuliff@gmail.com wrote: > Getting better. Now it's only > > Client host or user root@localhost.localdomain is not trusted by the > server.

pksaras@gmail.com wrote: > Hello Kate and ALL, > > I have similar odbc.ini and odbcinst.ini files. I am getting the same > error as Kate. > I have the sdk v2.9 installed. > Can you post your SQLHOSTS file? I have mine working now.