I use a combination of the linux's mysql client to access remote/local mysql
databases and have it save the output in a /tmp file
Then read it from Universe from the /tmp file - convert the Char(9) ->
char(253) and it's in a dynamic array
<1>=headers, <2+>=data rows. No extra expenses, no ODBC or bridges
required.
It's not integrated directly to universe, but I guess you could modify a
subroutine to write the output to a UV file once
It's back, assuming you know which fields are the keys.
Don't know if that helps.
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Thursday, October 06, 2011 11:54 AM
To: U2 Users List
Subject: Re: [U2] Question about accessing external SQL database
I created a simple .net app awhile ago to handle the connection so I
could just pass a sql statement to it plus the connection details. I
ended up just creating a voc pointer to a folder and I write the
response to a file and read it in UniVerse. I am a little interested
though in your suggestion to use uniobjects to return it. Were you
thinking of just writing the response to a file or is there some other
(more magical) possibility I am missing?
Jake
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Thursday, October 06, 2011 3:19 AM
To: 'U2 Users List'
Subject: Re: [U2] Question about accessing external SQL database
The bridge is required because there is no ms sql odbc driver for linux.
An alternative would be to use an install of UV on a windows machine to
do the actual odbc interaction, it would just use the standard ms odbc
driver. This in turn could communicate somehow to your main HP uv
install the required data (i.e. csv file, uv.net, soap etc).
Or as you say write a web service that runs on a windows machine and can
acquire the data.
Or write a .net console app for windows that gets the data and uses
uniobjects.net to send it back to your UV install. The app can be
instantiated via the windows scheduler every x minutes, or maybe using
Cygwin or samba from the HP box.
...
Rgds
Symeon.
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jason Lin
Sent: 06 October 2011 01:02
To: U2 Users List
Subject: [U2] Question about accessing external SQL database
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 the SQL database prefer not to create web services for this
purpose because his dept will need to maintain an additional web server.
(Alternatively, we could create our own web service on a Windows 2003
server which can connect to the SQL database server directly).
Instead, he offers two options: direct database connection to SQL
database (possibly via ODBC) or RPC.
I'm not familiar RPC in Universe but after reading documentation on
RPC.CONNECT and RPC.CALL functions, it looks like they were designed for
Universe to Universe (or Universe to Unidata) type of remote procedure
call.
Is that correct?
So the only other option is to use SQL/ODBC. After reading some
archived message from this mailing list, it looks we would need to
install a third party ODBC bridge/manager. Several messages recommended
Easysoft ODBC-ODBC Bridge but Easysoft lists its price at $2000!
Does anyone know if there any other ways of accessing external SQL
database from Universe?
Thank you.
Jason
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1410 / Virus Database: 1520/3939 - Release Date: 10/05/11
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
