Re: OpenServer 5.0 / Informix password bug? - Solution

Jay Hannah wrote: > SCO OpenServer 5.0 > DB-Access Version 7.20.UC5 > Windows 95 ODBC 3.0.23.1 (shouldn't matter?) > > Can anyone explain the following behavior? > --- > 1) ODBC to Informix works find with user "jhannah", password "1stPW". > 2) Telnet to OpenServer, change passwd jhannah to "DifferentPW". > 3) ODBC to Informix errors: > [Informix][sqlinfmx.dll] SQL Error (-952): > User's password is not correct for the database server. > 4) (ODBC with old password gives the same error -- as expected) > Shut down oninit, start it back up. > 5) ODBC to Informix gives the same error. > 6) Hmmm... Reboot OpenServer. > 7) ODBC to Informix gives the same error. > 8) Telnet to OpenServer, change passwd jhannah back to "1stPW". > 9) ODBC to Informix works fine. I stumbled across the (an) answer this morning: Consider two OpenServer 5.0 passwords: asdqwe12: Works fine in ODBC. asdqwe123: Gives above error in ODBC. My theory is that if an OpenServer 5.0 password is over 8 characters long, that ODBC mangles it somehow. There may be all kinds of work-arounds, but I'll just stick to 8 chars or less on my passwords instead (I'm a wuss). Thanks for the help, folks. I hope this post helps someone else. Cheers, Jay