Hi Harold,
[AD]
If you find that EDA does not work for you, we have a product called FusionWare
Legacy2SQL Bridge that will allow you to use subroutine calls in a BASIC
program to read/write SQL data as single-valued dynamic arrays to any ANSI
compatible SQL database that has a JDBC driver available. We have customers
working against both SQL Server and Oracle from Universe/BASIC programs, tested
and deployed on both AIX and Linux platforms. I don't know how Universe
licenses EDA, but we would definitely have an cost component.
If you'd like more info on this product, or a demo of the product, you could
contact us at 1-866-266-2326, 1, 167 or send an email to sales at
fusionware.net.
[/AD]
Robert Houben
CTO
FusionWare Corporation (formerly Liberty Integration Software)
-------- 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/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
