: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 7:30 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2][UV] Universe and SQL Server
The BEST WAY?? Is always my way of course chuckle.
... you might also consider the HTTP/XML
Of Tony Gravagno
Sent: February 2, 2006 19:15
To: u2-users@listserver.u2ug.org
Subject: RE: [U2][UV] Universe and SQL Server
Just because you're exchanging data with a relational database doesn't
mean you need to use SQL or ODBC with U2. You can use a middle-tier
ADO.NET dataset, and then use
Nick,
Thursday, February 2, 2006, 1:41:23 PM, you wrote:
NC Hello all,
NC We are currently looking into ways to share our data between
NC universe and SQL Server, and I am trying to get some suggestions
NC on the best way to do this. We are currently generating text
NC files in UV and ftp'ing
the data from both sides into datasets and
compares them for differences.
Thanks,
Nick Cipollina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of David Tod
Sigafoos
Sent: Friday, February 03, 2006 10:14 AM
To: Nick Cipollina
Subject: Re: [U2][UV
Nick wrote:
We are currently looking into ways to share our data between universe
and SQL Server...
I am in the process of trying to set up an OLE DB connection from SQL
Server to Unidata. Has any one done this? Can you provide example
connection strings?
Link server properties ask for
Nick Cipollina wrote:
We are currently looking into ways to share our data between universe and SQL
Server, and I am trying to get some suggestions on the best way to do this. We
are currently generating text files in UV and ftp'ing those files to a
designated location. We have a task
Nick:
I wonder how well an ODBC linked table can scale?
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick
Cipollina
Sent: Thursday, February 02, 2006 1:41 PM
To: u2-users@listserver.u2ug.org
Subject: [U2][UV] Universe and SQL Server
Hi Nick,
We have a few solutions to your project at FusionWare.
The most elegant solution is our mv2SQL product. It is very fast,
reliable and we have many customers using this product. Your processes
can be scheduled with DTS or run live.
If you would like further information on this or other
Use the UV Basic SQL client Interface (BCI) to directly update the
SQL-Server database.
The example program in the BCI manual is complete rubbish, the CONNECT
program in BP file in the UV account is a bit better.
There are some good examples in the Knowledge Base written by Paul Chang
at IBM
On 2/2/06, Nick Cipollina [EMAIL PROTECTED] wrote:
I know there are ways to communicate directly between SQL
server and Universe and I am looking for the best way to do this.
(Caveat: my experience is with UniData.)
What OS is UniVerse running on? If it's Windows, you can easily
access an
10 matches
Mail list logo
