Although I have only worked on a MS/MS environment, I believe that Universe
has a setup program to configure the ODBC definition. Once that is
completed and HPUX/Universe knows it is there, there should be no other sw
needed. But since this is all on HPUX I will leave it to others.
If you have any problems after connect I will be happy to chime in
DSig
David Tod Sigafoos
SigsSolutions, Inc.
-------- Original Message --------
Subject: RE: [U2] Reading data from an SQL Server Database from
Universe
From: "Oaks, Harold" <[EMAIL PROTECTED]>
Date: Tue, April 15, 2008 9:22 am
To: <[email protected]>
David:
Thanks for your response.
We have Universe running on hp's version of unix, "hpux". The MS SQL
Server is running on a Windows NT-based server.
Here is a simple test to see if one is connecting:
From Universe TCL one is supposed to be able to issue the CONNECT
command:
CONNECT data.source [options]
where "data.source" is the name of the source database, naturally. Can
that data.source database be an SQL Server database on another server?
If so, then there somewhere needs to be a way to say that it resides on
the server 'NT99' or whatever, and the database name on that server is
'MySQLdbName'.
Another response mentioned 3rd-party software. Perhaps that is required
to make this all work...
Harold
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, April 15, 2008 8:31 AM
To: [email protected]
Subject: RE: [U2] Reading data from an SQL Server Database from Universe
Harold,
Can you give your environments as this will make the replies easier
and more
to the point.
What is your Universe running on?
What is your "sql" server running on?
For my clarification .. you said ...
"I am simply trying to read data from a SQL Server database
into
Universe..."
I am getting from this that you want to connect to a server (MS Sql
so on
windows?) and simply access data from the server. Not the other way
around.
I just want to be clear about this as some of the replys don't seem
to go
this way.
DSig
David Tod Sigafoos
SigsSolutions, Inc.
-------- Original Message --------
Subject: [U2] Reading data from an SQL Server Database from
Universe
From: "Oaks, Harold" <[EMAIL PROTECTED]>
Date: Mon, April 14, 2008 4:43 pm
To: <[email protected]>
I am simply trying to read data from a SQL Server database into
Universe.
It's all supposed to be explained in the document "BASIC SQL Client
Interface Guide", but am missing one key point, it seems...
One defines the ODBC data source in the uvodbc.config file.
According
to the documentation the only information one puts into this
parameter
file are data source name and dbms type. For example:
<mysqldb>
DBMSTYPE = ODBC
are two lines in this file. This says the data source name is
'mysqldb'
and it's an ODBC type of database. OKfine.
That's it! For sources which are Universe databases, one also
enters a
service type and host. That makes sense.
Well - the SQL Server database I am interested in reading is on
another
server. WHERE do I specify the name of the server and the database
name?
Is it even possible in Universe to connect to a SQL Server database
on
another server?
Thanks for any help on this.
Harold D. Oaks
Sr. Analyst/Programmer
Office of the Budget and Information Systems
Clark County, Washington
ph: (360) 397-6121 x4132
fax: (360) 397-2342
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
