Hi Rudy ODBC & OLEDB comes with UniVerse already. I am sure you can do SQL Query Analyser directly to UniVerse, you don't have to go through SQL Server. If you need to do a stored procedure from SQL Server call to U2 data, then you could approach it the same way as you would integrating with Oracle or DB2 and call U2 as another SQL database. Use the SQL CALL procedure to get results from BASIC Subroutines. You can possible do it easier to use UniVerse to extract data from SQL Server and return it through UniVerse ODBC.
Regards David Jordan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: Thursday, 27 May 2004 8:29 AM To: [EMAIL PROTECTED] Subject: [U2] SqlServer/U2 Hello List, Does anyone know how to access Universe data from Sql Server 7.0 ? I have a need to retrieve data from Universe, which resides on a W2k box. I want to do this from Sql Query Analyzer, eventually for stored procedures, but for now from query analyzer for testing. I realize I can do this from VB/Uniobjects, convert to text file, etc., but my requirement is to access Universe data from query analyzer using tools that come w/the dbms, i.e no purchasing of any 3rd party odbc tools. I can go the other way, Uv as a client to Sql Server, using BCI from Uv without a problem, but what do I need to acces Uv from Sql Server ? We have Universe 10.04 on a W2K box. thx, rudy ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users