Sorry, I see that I misunderstood the client-server orientation when I responded the 1st time. The correct documentation to reference when UV is the ODBC client is the UV BCI guide. We have data going both directions and use a 3rd party ODBC driver from OpenLink to query MS SQL from UV. I think they also support AIX.
-John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Neil Richards Sent: Wednesday, June 30, 2010 4:40 PM To: U2 Users List Subject: Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC? As you are AIX you will also need the ODBC clients for AIX which are not provided by Rocket Software or Universe. I use a product from fusionware www.fwic.net<http://www.fwic.net> called the legacy MV2SQL bridge thats provides fast read and write access to our SQL server or Oracle databases with minimal programming. I remember Robert Houben writing a blog on this subject at http://www.fwic.net/NewsInfo/FusionWareIntegrationBlogs/tabid/116/EntryI d/6/Easy-access-to-SQL-data-from-MV-BASIC.aspx Neil ________________________________ From: [email protected] [[email protected]] On Behalf Of John Hester [[email protected]] Sent: Wednesday, June 30, 2010 4:10 PM To: U2 Users List Subject: Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC? Check out the UniVerse ODBC Guide included in the documentation on the UV installation media. If you don't have it, you can get it here: http://www.rocketsoftware.com/u2/pubs/library/ It's pretty straightforward. You'll also need the ODBC client available here: http://www.rocketsoftware.com/u2/downloads/ -John -----Original Message----- From: [email protected]<mailto:u2-users-boun...@listserver. u2ug.org> [mailto:[email protected]] On Behalf Of Ken Ford Sent: Wednesday, June 30, 2010 2:45 PM To: [email protected]<mailto:[email protected]> Subject: [U2] Retrieving data from remote SQL DB from Universe via ODBC? Fellow U2 users, The Universe documentation suggests that it is possible to retrieve data from a remote SQL DB on a Windows server from Universe using ODBC. We do the reverse here at present, but haven't done what I am attempting. Can anyone verify or shed some light on how to do this, please? We have Universe 10.3 running on AIX and have ODBC in use. Thanks, Ken Ford, FirstMac Pty Ltd, Brisbane, QLD Australia. _______________________________________________ U2-Users mailing list [email protected]<mailto:[email protected]> http://listserver.u2ug.org/mailman/listinfo/u2-users ________________________________ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
