Re: Extremely slow connect process and setnet32 processing

Jerry Flood (jflood@qsun.ho.att.com) wrote: : I've answered my own question and thought that others may run into : the same problem. When I configured my client to access the : 7.2 server, I set INFORMIXSQLHOSTS variable to a file name : on my pc (C:\\informix\\etc\\sqlhosts). I suspect that Informix : doesn't expect such a long filename causing some corruption : in memory resulting in these bogus DNS searches. In fact, : after I cleared the INFOMIXSQLHOSTS variable in setnet32, : setnet32 did not do any DNS calls and came up right away. : The connect times also went back to normal. On NT, there is no sqlhosts file. It's kept in the registry (put there either by setnet32 or manually). The INFORMIXQLHOSTS variable needs to be an NT-format machine name, such as \\\\joescomputer. This is actually a neat feature, as it allows you to designate one machine that has all the SQLHOSTS info for everybody on your network....one place to change sqlhosts data for your entire network. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" Slaving away on "INFORMIX DEBUGGERS Survival Guide", available early 1998 from Prentice Hall/Informix Press. If you have debugging tips, tools, or ideas to share, please send me some e-mail. ---------------------------------------------------------------------------