RE: ODBC/NT/Informix - slow connection

In our case, when we don't have the client's IP address in the /etc/hosts file on the UNIX server, it caused a very long delay (order of 30 seconds or more) between first running the telnet <UNIX-server> command and actually getting the UNIX server's login: prompt. Once the IP address is in the /etc/hosts file, it takes no more than two seconds. Maybe this has an impact on other autorization routes like ODBC or D4GL's WTK connections. Best regards, Edmund Nigel Gall Senior Information Systems Specialist Process Plant Services Limited Atlantic Avenue, Point Lisas Industrial Estate Point Lisas, Couva, Trinidad & Tobago, W.I. Tel: (868) 636 2906 x 274 Fax: (868) 679 3770 -----Original Message----- From: Tim Gilbert [mailto:timothy.j.gilbert@no.spam.boeing.com] Sent: 2000 January 17 9:15 AM To: informix-list@iiug.org Subject: Re: ODBC/NT/Informix - slow connection Try pinging your database host and see how long it takes. I had a problem where the NT server had an invalid IP address in the DNS lookup that caused a 20 second delay in connecting from a client. If you cannot resolve the delay, post additional info about your setup (database host, informix versions, OS, etc.) dg wrote: > > I've installed the the Informix ODBC driver on my NT workstation and > although I can get connected to the Informix DB, it takes a long time. The > initial connection to the database takes about 2-3 minutes and then 1-2 more > minutes to bring up the table list. > > Once connected and I run an application like MS-Query, the result set is > produced in less than 5 seconds. Pulling the results of MS-Query into Excel > or Access takes another 2-3 minutes. > > Does anyone have an idea of why the process of establishing a connection to > the Informix database takes so long? > > Thanks for your help!