Re: Error -406 problem

now, i think, the reason of the whole thing could be the localisation; there is a hint in the documation about error 406 together with localisation problems. i have a german version of nt, so i set the client_locale to "de_de.1252". the db_locale is set to "en_us.1252". does anyone have experience with this settings? tom Thomas Vatter wrote: > > hi dirk, > > services > yes, the services file exists in > %windir%\\system32\\drivers\\etc > the entry is "sqlexec 1525/tcp" and it is unique > > registry, ...SQLHOSTS ... > ive set > HOST to "my_computername" > PROTOCOL to "seipcpip" > ive also tried sesoctcp but ipcpip should be better > > ...se32\\CurrentVersion\\Environment > yes, its strange that there are no values there after > installation. > i ve now set two new values for HOST and PROTOCOL > as above. > > sysmaster database > hmm, as the connection to the database server is > first, before i can select a database, i just cant > give in a database to connect to; the error message > comes before this step. > > no, sorry, the connection is still not working :-( > > tom > > dschmidt@baan.com wrote: > > > > Hi Tom, > > > > check the following: > > 1. Service sqlexec exists in %windir%\\system32\\drivers\\etc\\services ? > > 2. Port number for sqlexec is unique ? > > > > try the following: > > in HKEY_LOCAL_MACHINE\\Software\\Informix\\SQLHOSTS\\... > > > > PROTOCOL "sesoctcp" > > HOST NT-Computername > > > > We don't use Standard Engine here. So, I don't know if it is ok that there > > are no entries in > > HKEY_LOCAL_MACHINE\\Software\\Informix\\se32\\CurrentVersion\\Environment. > > Check the NT environment variables under Control Panel/System/Environment. > > > > Does the standard engine have a sysmaster database ? If so try to get a > > connection with this database. > > > > Hope this helps, > > Dirk > > > > ================================================================ > > Dirk Schmidtpott Q.4 IBS GmbH > > Fon : 0049-5251-893-212 A Baan Company > > Fax : 0049-5251-893-300 Riemekestra'e 160 > > Mail: dschmidt@baan.com D-33106 Paderborn > > ================================================================ > > > > In article <3523C038.788F@mailszrz.zrz.tu-berlin.de>, > > vatd7021@mailszrz.tu-berlin.de wrote: > > > > > > hi again, > > > > > > here are the my settings of those critical values > > > > > > - INFORMIXDIR and INFORMIXDIR\\bin > > > yes, ive both in the search path > > > > > > - DB_LOCALE and CLIENT_LOCALE > > > ive set both to "de_de.1252"; database (se7.2) and client > > > are on a local windows in a german version > > > > > > - HKEY_LOCAL_MACHINE\\Software\\Informix\\se32\\CurrentVersion\\ > > > Environment > > > there are no entries... (?) > > > > > > HKEY_LOCAL_MACHINE\\Software\\Informix\\SQLHOSTS\\... > > > key LOCAL is set to > > > PROTOCOL "seipcpip" > > > SERVICE "sqlexec" > > > HOST "" > > > > > > tom > > > > > > --------------------------------------------------- > > > dschmidt@baan.com wrote: > > > > > > > > Hi, > > > > usually the reason for error -406 is that some DLL can not be found. Make > > > > sure that not only INFORMIXDIR occurs in the PATH variable, but also > > > > INFORMIXDIR\\bin. In some informix versions only INFORMIXDIR is set in the > > > > path during installation. > > > > > > > > Another possible reason is a wrong setting of environment variables. For > > > > example, I had a -406 because the environment variable DB_LOCALE was not > > set > > > > correct. So, check the settings in the registry under > > > > HKEY_LOCAL_MACHINE\\Software\\Informix\\OnLine\\CurrentVersion\\Environment and > > > > under > > > > HKEY_LOCAL_MACHINE\\Software\\Informix\\SQLHOSTS\\... > > > > > > > > I never found a reason for error -406 that has to do with memory problems. > > > > > > > > Hope this helps, > > > > Dirk > > > > > > > > ================================================================ > > > > Dirk Schmidtpott Q.4 IBS GmbH > > > > Fon : 0049-5251-893-212 A Baan Company > > > > Fax : 0049-5251-893-300 Riemekestra'e 160 > > > > Mail: dschmidt@baan.com D-33106 Paderborn > > > > ================================================================ > > > > > > > > In article <35209FF0.346FF3CD@earthlink.net>, > > > > Vijayakumar Bhavani <vbhavani@earthlink.net> wrote: > > > > > > > > > > Yes, it has nothing to do with memory. It is a configuration issue. > > > > > Make sure that you set the env. variables like INFORMIXDIR, > > > > > INFORMIXSERVER in the control panel\\system\\environment variables. > > > > > Reboot the system. If it still doesn't work, set the same using > > > > > informix utility setnet32. IT IS NOT A MEMORY PROBLEM. > > > > > > > > > > Regards, > > > > > Vijay > > > > > > > > > > vatd7021@mailszrz.zrz.tu-berlin.de wrote: > > > > > > > > > > > my local se7.2 server fails when i try to connect via dbaccess. > > > > > > the error message is '406 memory allocation failure'. > > > > > > the whole thing 'runs' on nt40 and i cant find any memory problems > > > > > > in the os. > > > > > > does anyone has experience with the 406 error? > > > > > > > > > > > > tom > > > > > > > > > > > > > > > > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > > > > http://www.dejanews.com/ Now offering spam-free web-based newsreading > > > > > > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > > http://www.dejanews.com/ Now offering spam-free web-based newsreading