Dave, I hit this with a Linux server last year and I'm hoping it's the same problem. Pete @ Epicor UK did some research and advised that Error 39207 refers to an incorrect LANG setting on a Unix server. LANG should be set to 'C' , if it isn't you'll hit this.
My problem was that the base system LANG setting was not C, but all my logins used a .profile script to set it to 'C' so ECL worked fine. Unfortunately, UniObjects doesn't execute .profiles, LOGIN paras or anything so it reverts to the base LANG (so in order for my theory to hold in your case, somebody must have changed something in AIX) Hth Piers -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor Sent: 07 March 2006 21:10 To: [email protected] Subject: [U2] UniObjects Select Error Hi, I've got an application that is written in VB.NET which uses UniObjects to connect to Unidata 6.0 on an AIX server. It's been working fine for months, and today seems to have 'broken'. I've stepped through the lines in VB.NET, and come up with what I think might be the offending error message. The error is error code 39207, which I have no reference as to it's meaning. I'm getting the error right after executing this two line code: Session.command.text = "SSELECT FSD BY DEL_DATE BY SORT_SEQ BY.DSND @ID WITH SELECT_DATE GE """ & SelectDateStr & """ AND WITH @ID # ""moved"" AND WITH NO PRM_DATE = ""PDt"" AND WITH NO CUST_NAME = """"" Session.command.exec() Notes: 1) My session is open, and has no error status. 2) The actual Select Statement created here is: SSELECT FSD BY DEL_DATE BY SORT_SEQ BY.DSND @ID WITH SELECT_DATE GE "03/1/06" AND WITH DISPLAYED # "Y" AND WITH @ID # "moved" AND WITH NO PRM_DATE = "PDt" AND WITH NO CUST_NAME = "" 3) The Session.command.text statement works correctly, as I can cut/paste it from the watch window to an ECL prompt and it works fine. I'm the only IT person working with this server and VB.NET code, and as I mentioned, I haven't changed anything in a months, so I'm not sure where to start. Any guess what the error code means, and/or what I could try to do to resolve this issue? Thanks, Dave ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
