> From: Jason Lin > 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 agree with suggestions to do this with tiers: Universe <> webservice <> localWin <> remote ODBC This can be done very quickly and it's open for many enhancements. The only issue I see is that a long query form localWin to remote ODBC could take more time than the webservice timeout. I'd implement this asynchronously, where the webservice just requests action of the localWin box which starts another thread to process the transaction. Then you can poll localWin for results, or have localWin write results via a share back to HP-UX where you can simply poll a type19 file for results. BTW, if all the web service does is ping localWin to do something consistent, you don't even need a web service for this. You can use CallHTTP or cURL with a GET or POST and maybe simple REST/querystring request (depending on how complex your queries are). This is another one that seems like magic but it can be done in a few minutes, and for free. Good luck. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users