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

Reply via email to