Re: [U2] Question about accessing external SQL database

2011-10-07 Thread Symeon Breen
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: 06 October 2011 16:54 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

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Symeon Breen
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

Re: [U2] Question about accessing external SQL database [AD]

2011-10-06 Thread Robert Houben
. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: October-06-11 1:19 AM To: 'U2 Users List' Subject: Re: [U2] Question about accessing external SQL database The bridge is required because there is no ms

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Holt, Jake
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

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread George Gallen
...@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

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Tony Gravagno
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

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 databases.

Re: [U2] Question about accessing external SQL database

2011-10-05 Thread Perry Taylor
We used EasySoft's ODBC driver with good success and I think it was quite a bit less expensive than the bridge. Perry Zirmed. Inc - Original Message - From: Jason Lin [mailto:temp...@ucla.edu] Sent: Wednesday, October 05, 2011 08:01 PM To: U2 Users List u2-users@listserver.u2ug.org