: [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 .
... you might also consider the HTTP/XML type
] Universe and SQL Server
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 genera
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'
TECTED] On Behalf 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.
If UniVerse is on Windows, BCI calls are definitely the way to go. IMHO, of
course.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
The BEST WAY?? Is always my way of course .
... you might also consider the HTTP/XML type options. One of the lads
here is experimenting with a Web Service, using the UniVerse SOAP API
and SQL2005, we're also currently using SQLXML quite successfully to
update SQL2000...
Stua
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 that as your data source for SQL Server or Universe.
For ADO.NET to U2 connectivity I'd use mv.NET, but you can use any tool
avai
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
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 Denv
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
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 Se
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 schedu
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 Produ
13 matches
Mail list logo
