Re: ODBC Problem -Reply
Peter Tashkoff (TASHKOP@kiwi.co.nz) wrote: : Letchu : My short answer would be to ditch intersolve and : move to Openlink. : Presuming you've already spent the money this is : the debugging procedure I used back in the bad old : days when I was in your position. : 1. Open a telnet session. If that works your : connection is OK. If it doesn't then your problem is : in the connection software config. : 2. If 1 works. Run the login tester in Informix. It : doesn't come up as an icon but it exists in the : informix/bin directory. I think it called ilogin.exe. : You need to connect to the stores database. If this : doesn't work then your problem is with I-NET. : 3. If 2 works. Open MSQuery and try to kick up a : connection. This will usually work once 1 & 2 are : taken care of. : If 3 doesn't work then you are buggered (to use a : technical term). I would move to an open driver. : I found Intersolve to be very flakey running off : MSAccess although that was as of last August; : perhaps it is better these days. : HTH : -- : -- : Peter Tashkoff : NZ Kiwifruit Project Consultant/DBA : Marketing Board. Standard Disclaimers apply : This posting may not be used by any commercial : organisation to vilify another. : >>> letchu.mal <letchu.mal@ca.slr.com> : 5/July/1996 11:33am >>> : Hi Gurus, : I have problem using Intersolv DataDirect : ODBC Driver. : Our hos is a AIX 3.2 and the database is : Informix SE 6.0. : When I use MS Query to access the Informix : host I get the : error 'getservbyname (WSANO_Data) System : call failed' . : Any one out there had a similar problem? Any : help will be : useful. : Regards, : letchu : letchu.mal@ca.slr.com : : ---------------------------------------------------------- : All views expressed above are my own and : does not belong to : those of my employer : : ---------------------------------------------------------- I suspected that you have not specify the service port number on your service file. All the best, Alan -- /* Alan Mak Siu Kei */ ^ ^ o o > ----- < Life is more than food, and the body more than clothes -Luke 12:23