Re: CSM issue
Posted in 2005
So now there is another problem. First I will say that without the csm option i can connect to my database just fine. Here are the steps i followed 1) Create a file called concsm.cfg in $INFORMIX$\\etc 2) Put the single line in that file SPWDCSM("c:\\informix\\bin\\libixspw.dll","", "p=1") 3) entered an options key in my registry Informix/SQLHOSTS/(servername)/OPTIONS of "csm=(SPWDCSM)" (where (severname) is the name of my server) 4) restart the informix server However I get the following error when testing the connection from the ODBC data source, IBM Informix ODBC Driver Setup page ------------------------- IBM Informix ODBC Error Message: --------------------------- Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]CSS: error processing initialization string: C:\\Program Files\\Informix\\Client-SDK\\/etc/concsm.cfg. --------------------------- OK --------------------------- So I think I have some environment variable set badly, but no idea which. First it is pointing to my client SDK installation as opposed to my informix installation, and second its appending "/etc/concsm.cfg" which has the slashes the wrong way around for a windows box! Any idea where I can change these options? I will scour the help files, but its a bit hit or miss cheers