RE: [U2] Upgrading Universe
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Didn't the ODBC driver change between those versions? -Original Message- From: Mark Eastwood [mailto:[EMAIL PROTECTED] Sent: 15 August 2005 21:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Upgrading Universe ODBC; it's a lot pickier about dictionary data-types. -Original Message- Is there going to be any unexpected surprises if an upgrade is made from Universe 10.0 to 10.1.11 on a Windows 2000 server? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SOAP requests from Universe
I'm trying to make a SOAP request from Universe 10.1.10, but can't work out exactly how to use the SOAPSetRequestHeader function (the other functions appear to be pretty obvious). I know what I need in the header, but am unsure how to put it into the necessary databasic. Does anyone have an example of how it works please? Malcolm IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: FW: Re[2]: [U2] Connection Problems with Ud6 and UV10
Anthony, thanks for the reply .. Tuesday, August 16, 2005, 2:58:24 AM, you wrote: AY I'm following this well out of date so somebody may have given you the AY answer ... nope .. no one has won the silver ring yet g AY Does the path to where the admin programs are stored contain a space? AY For example, in Program Files? If so, REINSTALL SOMEWHERE ELSE. AY I made the mistake of changing the default ( C:\IBM\...) and AY admin, etc, AY was promptly screwed up. Everything appeared to work, but it just AY didn't AY :-( g I think i ran into this a long time ago when I first started to play with Universe at home. Sadly I am just using the install defaults. But you were the first to suggest this .. thanks AY -Original Message- AY From: [EMAIL PROTECTED] AY [mailto:[EMAIL PROTECTED] On Behalf Of David Tod AY Sigafoos AY Sent: 11 August 2005 00:02 AY To: Ron White AY Subject: Re[2]: [U2] Connection Problems with Ud6 and UV10 AY Ron, AY Wednesday, August 10, 2005, 1:01:03 PM, you wrote: RW Launch UniAdmin and select Telnet under the Network services RW header. When RW the screen appears, the first thing on the screen is the desired RW telnet RW port number. RW After entering your port number, click the stop button to stop the AY UV RW services RW and then click start to restart them. If you are accessing UV with AY a RW terminal RW emulator you will have to change your telnet port setting in the RW emulator as well. AY I start UniAdmin and Local Host shows on the left. AY The menu items are File, View, COnnect, Admin, Window, Logging and AY Help AY Under Admin is Network Services. Problem is that ALL items under AY Admin are grayed out. AY I find that if i use uniadmin on another server those items don't AY become available until a connection has been made. AY So is this one of those chicken and egg things G -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ 'Politics is like driving. To go backward, put it in R. To go forward, put it in D' unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SOAP requests from Universe
Malcolm, We do not specifically set header information in our SOAP interfaces. But, you should be able to add a line similar to: statusvalue = SOAPSetRequestHeader(Handle, SendValue) after the create request. Handle and SendValue should be able to be variables or hardcoded values. HTH, Mike Dallaire Mortgage Builder Software Inc. (248) 208-3223 ext. 103 [EMAIL PROTECTED] www.mortgagebuilder.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kay, Malcolm Sent: Tuesday, August 16, 2005 9:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP requests from Universe I'm trying to make a SOAP request from Universe 10.1.10, but can't work out exactly how to use the SOAPSetRequestHeader function (the other functions appear to be pretty obvious). I know what I need in the header, but am unsure how to put it into the necessary databasic. Does anyone have an example of how it works please? Malcolm IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Windows Service Packs
Has anyone experienced problems when Windows Service Packs were installed along with automatic security updates on W2000? If so, please explain what happened? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Windows Service Packs
Things broke! Look out for extra security settings that magically appear, new services, etc, etc. I have a personal vendetta against the automatic download and install of service packs. I turn it off. Nothing like having a server update itself overnight and come up in the morning with some new spiffy security settings. Look out for the restrictive firewall settings too. I turn that off as well. One of my pet peeves with windoze is that it's too damn easy to run workstation class software on a server. Trim out all the anti viral crap (you don't allow any of the unwashed masses to map drives to your production machine now do you?). Turn off the auto downloads of everything under the sun (you don't really give a damn about the latest update to Outlook Express because you've already removed it right?). You get the drift, trim down all the extraneous junk on those winoze servers and you might find that they wake up and do some real work for a change! :-) On 8/16/05, Baruch Salamander [EMAIL PROTECTED] wrote: Has anyone experienced problems when Windows Service Packs were installed along with automatic security updates on W2000? If so, please explain what happened? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SOAP requests from Universe
Malcolm, This is how we do it for callHTTP. HEADEROPTION = Content-Type DEFAULTSET = setHTTPDefault(HEADEROPTION,'text/html':CHAR(59):'charset=utf-8') HTH, Mike Dallaire Mortgage Builder Software Inc. (248) 208-3223 ext. 103 [EMAIL PROTECTED] www.mortgagebuilder.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kay, Malcolm Sent: Tuesday, August 16, 2005 11:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOAP requests from Universe Mike My problem is that I don't know what to put in the sendvalue, in ASP we use have statements like:- xhttp.setRequestHeader Content-Type, text/xml; charset=utf-8 but what's that supposed to look like in a single string (sendvalue)? However, if the header isn't necessary, I'll see if I can get away without it. Malcolm -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: 16 August 2005 15:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOAP requests from Universe Malcolm, We do not specifically set header information in our SOAP interfaces. But, you should be able to add a line similar to: statusvalue = SOAPSetRequestHeader(Handle, SendValue) after the create request. Handle and SendValue should be able to be variables or hardcoded values. HTH, Mike Dallaire Mortgage Builder Software Inc. (248) 208-3223 ext. 103 [EMAIL PROTECTED] www.mortgagebuilder.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kay, Malcolm Sent: Tuesday, August 16, 2005 9:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP requests from Universe I'm trying to make a SOAP request from Universe 10.1.10, but can't work out exactly how to use the SOAPSetRequestHeader function (the other functions appear to be pretty obvious). I know what I need in the header, but am unsure how to put it into the necessary databasic. Does anyone have an example of how it works please? Malcolm IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ IMPORTANT NOTICE. This communication is intended solely for the person (s) or organisation to whom it is addressed. It may contain privileged and confidential information and if you are not the intended recipient (s), you must not copy, distribute or take any action in reliance on it. If you have received this e-mail in error please notify the sender and copy the message to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Windows Service Packs
When things broke, what was done in order to restore the system to its previous condition? u2-users@listserver.u2ug.org writes: Things broke! Look out for extra security settings that magically appear, new services, etc, etc. I have a personal vendetta against the automatic download and install of service packs. I turn it off. Nothing like having a server update itself overnight and come up in the morning with some new spiffy security settings. Look out for the restrictive firewall settings too. I turn that off as well. One of my pet peeves with windoze is that it's too damn easy to run workstation class software on a server. Trim out all the anti viral crap (you don't allow any of the unwashed masses to map drives to your production machine now do you?). Turn off the auto downloads of everything under the sun (you don't really give a damn about the latest update to Outlook Express because you've already removed it right?). You get the drift, trim down all the extraneous junk on those winoze servers and you might find that they wake up and do some real work for a change! :-) On 8/16/05, Baruch Salamander [EMAIL PROTECTED] wrote: Has anyone experienced problems when Windows Service Packs were installed along with automatic security updates on W2000? If so, please explain what happened? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Anyone here using Cold Fusion to access UniVerse?
Hi Allen - I'm having problems with CFMX7 and UV/ODBC also and not having much luck. (UVpe 10.1) *Very* well known issue, unfortunately, no workarounds that I'm aware of, see the ff. thread @ the CF forums: http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6threadid=454501forumid=1 Upshot is, no one seems to be able to get it to work. Very disappointing, and I don't know who to blame, but Macromedia seems the likeliest culprit. I was able to work around the issue by using UVSH to go directly into UV from the cfexecute tag. It works really well but then you are no longer using ODBC/SQL and is highly proprietary. One of the best things about it, is that it releases your UV login once the query finishes and returns to CF. I was very surprised at just how fast this was but did not like the non-standard approach. Don't know how it would work on a large scale application however. My guess is very fast and very flexible. Interesting, are they running off the same machine, presumably? Another possible solution is to use FusionWare's eTools ODBC driver. I think this is the old Liberty/ODBC driver and server. I really like the product when I used it, but am looking for the NO cost solution at least while prototyping. We're not running the UV system on Windows, unfortunately, but these do look interesting. Ultimately, we're going to go the web services route so an additional investment likely not likely for us. If you could share your CF connectivity parameters for UV/JDBC, I would appreciate it. I've not played with that yet. (Just another tasty ingredient in the soup!) Yup, this was a hard one for me to get, I was following some bad advice posted in the cf forums, here's what works for me in the datasource setup: CF Data Source Name uvjdbcvhup JDBC URLjdbc:ibm-u2://192.168.100.99:31438/HS.SERVICE Driver Classcom.ibm.u2.jdbc.UniJDBCDriver Driver NameUniJDBCDriver User Name(valid user) Password(valid user password) where HS.SERVICE is the name of the UV account that the user logs into, in our case, HS.SERVICE The other thing is to make sure that your classpath in the CF Java VM settins poitns to the two IBVM deliverd files, unijdbc.jar asjava.zip ; in my case the classpath looks like: C:\IBM\UniDK\jdbc\lib\unijdbc.jar,C:\IBM\UniDK\uojsdk\lib\asjava.zip The webservices idea is a great way to go, but requires significant development. Once I get this site up and running, webservices will be next. Us too, after JDBC. Good luck all around Allen! -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Windows Service Packs
Always backup before doing a service pack install! Once you've gone down the oh no, what now batman? road a few times you'll *never* install *any* software without backing up first. You may be able to go into start_settings_control panel_Add/Remove Programs and find the service pack and deinstall it; that is if it is not one of the upgrades that are non-removable. I had a complete meltdown in 12/2003 - first the drive broke down, then on a new drive 2 days later my motherboard fries (Merry Christmas to me, not). I put a new system together, grabbed my data files from backup, upgraded from win98 to w2000 loaded all my apps from scratch and all I had left was to load Norton AV. It crashed and burned and I had to start over. Now when I put a system together, I do a quick backup after each app install. Sometimes it really pays to be paranoid! hth, Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Baruch Salamander Sent: Tuesday, August 16, 2005 10:44 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Windows Service Packs When things broke, what was done in order to restore the system to its previous condition? u2-users@listserver.u2ug.org writes: Things broke! Look out for extra security settings that magically appear, new services, etc, etc. I have a personal vendetta against the automatic download and install of service packs. I turn it off. Nothing like having a server update itself overnight and come up in the morning with some new spiffy security settings. Look out for the restrictive firewall settings too. I turn that off as well. One of my pet peeves with windoze is that it's too damn easy to run workstation class software on a server. Trim out all the anti viral crap (you don't allow any of the unwashed masses to map drives to your production machine now do you?). Turn off the auto downloads of everything under the sun (you don't really give a damn about the latest update to Outlook Express because you've already removed it right?). You get the drift, trim down all the extraneous junk on those winoze servers and you might find that they wake up and do some real work for a change! :-) On 8/16/05, Baruch Salamander [EMAIL PROTECTED] wrote: Has anyone experienced problems when Windows Service Packs were installed along with automatic security updates on W2000? If so, please explain what happened? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upgrading Universe {Unclassified}
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Philip Ellis Sent: Tuesday, 16 August 2005 19:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Upgrading Universe Didn't the ODBC driver change between those versions? It certainly did, but this shouldn't be an 'unexpected surprise' ;-) The 10.1 ODBC server is incompatible with the 10.0 ODBC Client So, you must upgrade *all* the machines with an ODBC Client to the 10.1 version before you upgrade your UV server(s). There is also a 'gotcha' with the new client and authentication, see the thread [U2] UV/ODBC v10.1 clients fails to save password in the list archives HTH Mike Is there going to be any unexpected surprises if an upgrade is made from Universe 10.0 to 10.1.11 on a Windows 2000 server? The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Anyone here using Cold Fusion to access UniVerse?
We are using CF with Universe. It took awhile to get it working. One of the problems was an issue in the /etc/inetd.conf file there were two lines referencing the rexec service. The line with the -c at the end is the line you want and there maybe an empty line after the good line in the file, that needs to be deleted. This was on AIX 4.3 and UV 9.6 -Original Message- From: Allen Highnote [SMTP:[EMAIL PROTECTED] Sent: Sunday, August 14, 2005 1:37 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Anyone here using Cold Fusion to access UniVerse? Peter, I'm having problems with CFMX7 and UV/ODBC also and not having much luck. (UVpe 10.1) I was able to get UV/ODBC to work with MS-Query and was able to get the CF datasource config to test the UV/ODBC connection as OK but when I ran a CF query against it, I received an Invalid Argument or mismatch message (or something like that). Is that what you are experiencing? I've tried this with CF and UVpe on XP using CF's internal web server as well as moving UVpe to W2K server with IIS and got the same results. I was able to work around the issue by using UVSH to go directly into UV from the cfexecute tag. It works really well but then you are no longer using ODBC/SQL and is highly proprietary. One of the best things about it, is that it releases your UV login once the query finishes and returns to CF. I was very surprised at just how fast this was but did not like the non-standard approach. Don't know how it would work on a large scale application however. My guess is very fast and very flexible. I wrote a couple of CF components as well as a couple of small UV server applications that help handle the UV to CF connectivity including UV reads and writes. Also wrote a rudimentary prototype of the MV REPLACE statement in CF. I finally tabled the task and moved on to testing UniData which is working well so far. I'm developing a CF website that works with either MS-Access, UniData, Universe (maybe), mySQL, and possibly SQL Server. (Kind of a throw everything in the pot and call it vegetable soup project!) Another possible solution is to use FusionWare's eTools ODBC driver. I think this is the old Liberty/ODBC driver and server. I really like the product when I used it, but am looking for the NO cost solution at least while prototyping. If you could share your CF connectivity parameters for UV/JDBC, I would appreciate it. I've not played with that yet. (Just another tasty ingredient in the soup!) The webservices idea is a great way to go, but requires significant development. Once I get this site up and running, webservices will be next. Allen Highnote [EMAIL PROTECTED] (requires a challenge response) Phone: three 66-3313 in the 5 six 2 area code --- Peter Ivanick [EMAIL PROTECTED] wrote: Thanks Tony, and indeed several people have suggested that we bypass the odbc/jdbc issue altogether we'll likely be looking to do that, although we aren't currently exposing any web services (just got upgraded to 10.1.4 last month); in this case we've got a rather severe time/resource constraint but do need to upgarde CF from 5.1 to CFMX 7, which doesn't handle ODBC with UniVerse at all, and no help from Macromedia in the offing, so JDBC is our best bet for the timeframe. Many thanks for the help. Tony Gravagno wrote: I'm not sure about your architecture, but just to open some possibilities... I used CF years ago connect into a back end application using CFHTTP queries rather than ODBC. If you're already exposing U2 business rules as a Web Service then using CF to generate the UI becomes a no brainer. If not, well, that's one of the benefits of modularization and exposing code as UI-independent rules, which is after all what Stored Procedures are all about. HTH T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
