Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Jason Lin
On 10/6/2011 1:51 PM, Tony Gravagno wrote: I agree with suggestions to do this with tiers: Universe<> webservice<> localWin<> remote ODBC I think that is the best approach for me as well since I already how to create web services in .Net Framework environment to query access SQL databa

[U2] Question about accessing external SQL database

2011-10-05 Thread Jason Lin
Hi, I am exploring a good way to access data on an external SQL database from our Universe (10.2.7) environment running on HP-UX (11.23). I personally prefer to use SOAP API in Universe BASIC to query the database provided the appropriate web service is available. However, the owner of t

Re: [U2] Problem reading XML node value in Universe BASIC

2011-10-04 Thread Jason Lin
Quoting Ross Craig : > Jason > > Maybe you need a /text() in the path. > > Node="test/name/text()" > > Just a guess. > > Ross Hi Ross, Rick Nuckolls mentioned about text node in another reply. After some thoughts, I think you are right and that it makes sense to add text() because value of th

Re: [U2] Problem reading XML node value in Universe BASIC

2011-10-04 Thread Jason Lin
Quoting Rick Nuckolls : I do not have the manual with me at the moment, but you need to go down one more level. The text is in the text node under "name" -Rick Hi Rick, Yes. You are right about the text node which is separate from the element node. Jason __

Re: [U2] Problem reading XML node value in Universe BASIC

2011-10-04 Thread Jason Lin
Quoting Ross Craig : Jason Maybe you need a /text() in the path. Node="test/name/text()" Just a guess. Ross Hi Ross, Thanks for that tip. I didn't think I would need to add text() to the XPath expression when calling XDOMLocate function because 1) the XDOMLocate is meant to locate a

[U2] Problem reading XML node value in Universe BASIC

2011-10-04 Thread Jason Lin
Hi. I tried to use the XDOM API (XML for BASIC API Programmatic Interfaces) in Universe Basic for parsing XML file and extracting element values but for some reason I got error when calling the XDOMGetNodeValue function. Here is an example. Suppose I have a simple XML file called "TEST.xml"

Re: [U2] Uniobject.Net Plus ASP.Net web service performance (was Re: Error connecting to Universe using Web Service Developer Tool)

2010-02-24 Thread Jason Lin
Quoting djordan : > I had a problem like this due to the Uniobject.Net client was an old > version, I updated it to the latest version and this improved the process. > > David Jordan Hi David, Thanks for the tip on new vs old versions of Uniobject.Net. After some testing, I found an workaround b

[U2] Uniobject.Net Plus ASP.Net web service performance (was Re: Error connecting to Universe using Web Service Developer Tool)

2010-02-20 Thread Jason Lin
My first attempt using Uniobject.Net in a ASP.net web service is a bit disappointing. The issue I have is the performance of OpenSession command. It takes about 4 seconds to execute Uniobject's OpenSession command. I verified OpenSession's slow performance in a C# program by doing open and closi

Re: [U2] Error connecting to Universe using Web Service Developer Tool

2010-02-17 Thread Jason Lin
On 2/17/2010 4:14 PM, Tony Gravagno wrote: I have a video on our website showing ways to do web services with ASP.NET: nospam.pleaseNebula-RnD.com/products/gallery.htm My connectivity tool of choice is mv.NET, which is used in the video, but for this purpose one can easily use UO.NET instead. F

Re: [U2] Error connecting to Universe using Web Service Developer

2010-02-17 Thread Jason Lin
Quoting Norman Bauer : > Also, make sure that 31438 is open on the firewall for the server. > > Norm Norm, I don't think the server has block port 31438 because Uniobject.net works just fine assuming that uniobject communicates with unirpc daemon over port 31438. Jason __

Re: [U2] Error connecting to Universe using Web Service Developer Tool

2010-02-17 Thread Jason Lin
Quoting Symeon Breen : > Personally i use asp.net and uniobjects.net to do web services, the reason > being it is very simple this way and ultimately extendable, but also my web > layer is in iis and this is where i want my webservices to sit, not some > 'other' http server ... Symeon, Good to

Re: [U2] Error connecting to Universe using Web Service Developer

2010-02-17 Thread Jason Lin
Quoting David Jordan : > I have seen this before. Check all the permissions such as > c:\ibm\uv\bin\uvtemp > > Regards > > David Jordan Jordan, We are running HP-UX but I don't think we have any permission issues with temp directories used by Universe. Jason __

Re: [U2] Error connecting to Universe using Web Service Developer Tool

2010-02-17 Thread Jason Lin
Quoting Bill Haskett : > Jason: > > When I tried the WSD several years ago I needed a "connection > pooling" license, otherwise the connection wouldn't work. I'm not > sure this is still required but it was when I tried it. Secondly, I > may have had some problems with casing, so make sure th

[U2] Error connecting to Universe using Web Service Developer Tool

2010-02-16 Thread Jason Lin
Hi. I tried to use the Web Service Develper tool to connect to our Universe database (ver 10.1.2 running on HP-UX B.11.0) and I kept getting RPC error "unable to load the subroutine on the server". I have verified that the unirpc daemon is running and it is using the default port # 31438. P

[U2] Question about Uniobject and session encryption

2008-07-18 Thread Jason Lin
Hi all. I am having trouble using session encryption in Uniobject and I hope someone can help me out on this issue. According to the "UniObjects for .NET Developer’s Guide", Uniboject allows encryption applied to its UniSession object. On page 3-34, I see two properties of UniSession exp

RE: [U2] Error process XML files

2007-06-01 Thread Jason Lin
On Fri, 1 Jun 2007, gerry-u2ug wrote: > We ran into such a situation way back, the problem was the unix > environment variable SHLIB_PATH was not being set ( /usr/uv/bin ) . > For user logins this can be done in your .profile but for other non-user > processes ( phantom , uv-odbc , uniobjects etc

[U2] Error process XML files

2007-05-31 Thread Jason Lin
Hi all. I was testing a program to extract XML data using Universe BASIC's PrepareXML, OpenXMLData functions and so on and I got the following error messsages: Program "TEST.EXTRACT.XML": Line 8, Can't load "/usr/uv/bin/libxalan-c1_3.sl": shared lib error: No such file or directory Program "TEST.

Re: [U2] Connecting to a remote Universe server in Universe Basic

2007-05-01 Thread Jason Lin
On Tue, 1 May 2007, Michael Rajkowski wrote: > In release 10.2 of UniVerse, ( and 7.1.8 of UniData ) U2 now has the Web > Services Developer. With this tool you can now create services that can be > used in a SOA environment. This along with client side SOAP support from > basic, you can use ser

RE: [U2] Connecting to a remote Universe server in Universe Basic

2007-05-01 Thread Jason Lin
On Tue, 1 May 2007, Hona, David S wrote: > If you don't want to purchase any third-party software or add-on modules > for UV and still code it in BASIC, then the BASIC Call Interface (BCI) > is the way to go. Depending on your UV release, you may need to "enable" > the UCI/BCI module - later relea

Re: [U2] Connecting to a remote Universe server in Universe Basic

2007-04-30 Thread Jason Lin
Clifton Oliver wrote: You need to be careful!! If you do this and System A is updating information on System B and System B is updating the same files YOU HAVE NO SHARED LOCKING! That means that not only will READUs on one system not see the READUs on the other system, but they don't see each

Re: [U2] Connecting to a remote Universe server in Universe Basic

2007-04-30 Thread Jason Lin
Thanks, Peter and John. Your suggestions to use pointers for remote file system probably will work. One concern I have is the file locking. According to the Universe Admin manual, ALLOWNFS allows opening files on remote servers but no locks are maintained. That may not be an issue if all we nee

[U2] Connecting to a remote Universe server in Universe Basic

2007-04-30 Thread Jason Lin
Hi all. Does anyone know what is the easiest way for Universe BASIC programs to access or update records residing on another Universe server? In Visual Basic, this can be done easily using UniObject. But I am surprised that Universe BASIC itself does not seem to have the capability provided by U

RE: [U2] Daylight savings time change and SLEEP command

2007-03-22 Thread Jason Lin
On Thu, 22 Mar 2007, John Jenkins wrote: > Jason > > By the behaviour you describe: > > Sleep until a time would appear to operate as a SLEEP for the interval > between *now* and the specified time. This would be set at the moment that > the SLEEP is issued. E.g. If that is how SLEEP works then

[U2] Daylight savings time change and SLEEP command

2007-03-21 Thread Jason Lin
Hi all. I noticed that several processes running as phantoms in Universe 10.1.2 on HP-UX B.11.00 started their daily work one hour late since the new daylight savings time change. These phantom processes have been running for several months and they are basically PQ procs that uses the SLEEP comm

Re: [U2] Question about using CallHTTP and secured connection

2007-01-11 Thread Jason Lin
Symeon Breen wrote: Hi Jason - I find the best way to debug these is to turn protocol logging on At the top of the program put something like res=protocolLogging("SymTest.log","ON",10) and at the bottom res=protocolLogging("SymTest.log","OFF",10) The file SymTest.log will then contain detail o

[U2] Question about using CallHTTP and secured connection

2007-01-09 Thread Jason Lin
Hi all. Does anyone has a sample program that demonstrate how to submit a http request over secured connection? I was able to write a program to submit SOAP requests over regular HTTP connection but when I modify it to use secured connection it failed. Without going into the detail of the SOAP X

Re: [U2] SOAP and secured HTTP

2007-01-08 Thread Jason Lin
On Mon, 8 Jan 2007, Symeon Breen wrote: > No it doesn't - if you look at the other api's, that the soap one is built > upon, > > > i.e. the http and the socket ones, they both have a opensecure method that > you use a security context with. What i have done to do soap on https is use > the http a

[U2] SOAP and secured HTTP

2007-01-05 Thread Jason Lin
Hi. I am currently testing the SOAP API and I noticed that if the web service URL is a secured connection (https), the program will wait indefinitely for response from the web server. On the other hand, if the web service URL uses regular HTTP connection, the SOAP API works just fine. The testin

Re: [U2] [UV] OpenXMLData error

2006-11-18 Thread Jason Lin
Don Verhagen wrote: Jason, Unless it's a typo, you quoted the "TEST_XML_HANDEL" variable in your OpenXMLData statement Should by STATUS = OpenXMLData(TEST_XML_HANDEL,.) not OpenXMLData("TEST_XML_HANDEL",...) Don V Don, I you read my original posting closely, you will see I have al

[U2] [UV] OpenXMLData error

2006-11-17 Thread Jason Lin
Hi guys. I am doing some testing of receiving XML data into Universe database and I and kind of stuck with the OpenXMLData function which keeps returning a INVALID.XML.HANDEL error. Here is what I attempted to do in a BASIC program mostly by following the examples in BASIC Extension documentation

Re: [U2] [UV] Strange characters in XML output

2006-11-16 Thread Jason Lin
[EMAIL PROTECTED] wrote: Hmmm, I haven't seen anything like this but the "L10" being appended looks suspiciously like a bad conversion justification that might be appending to the file name. I would check all the dictionaries involved in this listing, including @id, @, @select, any 'PH's and any

Re: [U2] [UV] Strange characters in XML output

2006-11-16 Thread Jason Lin
Minor correction to my previous message: The element IDs in my previous message should have been the name of the file with "_record" appended to the end. For example, PERSONNEL.F_record. After I did more testing, I notice the strange charaters are attached to the element IDs if I use Retrieve wit

[U2] [UV] Strange characters in XML output

2006-11-16 Thread Jason Lin
Hello. This is a issue I have posted on this list before but I received no replies. Anyway, here it is again. I noticed that when I use Retrieve with TOXML keyword, the resulting XML output often contains extra characters in the element IDs. The followings are few examples (using the demo files

Re: [U2] UniObject.Net error

2006-10-02 Thread Jason Lin
Victor St Clair wrote: Hello Jason For us, this usually happens when you close a session that's not open. Typically this happens because an I/O step fails in a way that causes the session to close. I think, but I'm not sure, that in some cases UniObjects does not throw an error. Or, it could

Re: [U2] UniObject.Net error

2006-10-02 Thread Jason Lin
Brian Leach wrote: Jason Make sure you to an explicit CloseSession before exiting: Try UniObjects.CloseSession(Sess) UniObjects.CloseAllSessions() Catch ex As Exception End Try I suspect Dispose destroys the objects out of sequence. I've been using UO with .NET 2 for a year and that