Unanswered: Problem in accessing Informix DB (9.2-IDS2000 server) through ODBC
I have the following configuration.
Informix Server : Informix 9.2 (IDS 2000) Running on Solaris 8 machine
Client : Windows 2000 machine installed with Informix ODBC
Now I am trying to connect Informix DB Server through the ODBC.In informix DBserver I have enabled Simple password encryption and it is must for smooth running of my application (csm=(SPWDCSM) ). Now when I am trying to connect to Informix server through ODBC it is giving Authentication error.The handsone work around is to disable the csm option.But I would like to keep the encryption option enabled at the same time I should be able to access the Informix DB through ODBC.
Is it possible like Both Informix server and Client should have same csm encryption facility.If it is correct how can we configure these settings.I need suggestions on how to configure the CSM option in Informix Client on my windows machine.
I have configure-concsm.cfg the csm option like this in my Informix server on solaris machine
Now what are all the steps I follow to configure the csm option from the Client.I have installed Informix ODBC driver (2.90.TC4) and I do not found libixspw.so in the lib and its sub directories.Please help me on this ..
_ On server
By default $INFORMIXDIR/etc/concsm.cfg or define variable INFORMIXCONCSMCFG=$INFORMIXDIR/etc/concsm.xxx and
add this file on $INFORMIXDIR/etc.
In the file $INFORMIXDIR/etc/comcsm.xxx write:
The name dm4 is add in sqlhosts file: DBSER CONNECT HOSTS csm=(dm4).
_ On Client
By default %INFORMIXDIR%\etc\concsm.cfg
In the file %INFORMIXDIR%\etc\comcsm.cfg write:
Thanks for your reply.Actually the problem get resolved after setting the client configuration file( comcsm.cfg ) like the below