Re: [U2] Unix to SQLServer

2010-08-17 Thread George Gallen
.org] On Behalf Of Wols Lists > Sent: Tuesday, August 17, 2010 4:42 AM > To: U2 Users List > Subject: Re: [U2] Unix to SQLServer > > On 17/08/10 05:47, Norman, David (Health) wrote: > > Thanks to all who responded. After managing to extract a bit more > info from the user

Re: [U2] Unix to SQLServer

2010-08-17 Thread Wols Lists
On 17/08/10 05:47, Norman, David (Health) wrote: > Thanks to all who responded. After managing to extract a bit more info from > the user on what they think they might want, it now seems that all we need to > do is put a CSV in a Samba share that can then be imported into MS SQL > Server. Simpl

Re: [U2] Unix to SQLServer

2010-08-16 Thread Norman, David (Health)
Thanks to all who responded. After managing to extract a bit more info from the user on what they think they might want, it now seems that all we need to do is put a CSV in a Samba share that can then be imported into MS SQL Server. Simple. David Norman Senior Software E

Re: [U2] Unix to SQLServer

2010-08-14 Thread JPB-U2UG
Hear, hear, and as an end user I welcome knowing about new, and old, products that are available for my use. Jerry -- From: "Larry Hiscock" Sent: Friday, August 13, 2010 11:26 AM To: "'U2 Users List'" Subject: R

Re: [U2] Unix to SQLServer

2010-08-13 Thread Wols Lists
On 13/08/10 14:36, George Gallen wrote: > I'm making the assumption that the UV server is on Unix, and the SQL > server is on ... Well, windows. That assumes that it is MS SQL-Server, and not just any old SQL server such as MySQL, PostgreSQL etc. > Using perl, there is nothing that needs to be a

Re: [U2] Unix to SQLServer

2010-08-13 Thread Larry Hiscock
>> At the risk of being roasted for mentioning my "vendor product" (see other threads - it seems to be unpopular) ... I'm not speaking for the U2UG officially, but as a moderator on this list, and as the list host. IMHO, there is nothing wrong with mentioning or endorsing a product, whether it's

Re: [U2] Unix to SQLServer[AD]

2010-08-13 Thread David Cooper (Support#2)
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: 13 August 2010 16:25 To: U2 Users List Subject: Re: [U2] Unix to SQLServer[AD] At the risk of being roasted for mentioning my "vendor product" (see other threads - it seems to be unpopular) I'd like to point ou

Re: [U2] Unix to SQLServer[AD]

2010-08-13 Thread Robert Houben
more info about this at www.fwic.net. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, August 13, 2010 4:48 AM To: 'U2 Users List' Subject: Re: [U2] Unix to SQLServer David Thr

Re: [U2] Unix to SQLServer

2010-08-13 Thread George Gallen
I'm making the assumption that the UV server is on Unix, and the SQL server is on ... Well, windows. Using perl, there is nothing that needs to be added to the windows system, or any configuration changes (other than allowing the IP of the unix machine to connect and/or with a particular u

Re: [U2] Unix to SQLServer

2010-08-13 Thread Bob Witney
MS BIZTALK WORKS FOR US -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 13 August 2010 13:37 To: U2 Users List Subject: Re: [U2] Unix to SQLServer Another option would be export a flat file, and

Re: [U2] Unix to SQLServer

2010-08-13 Thread George Gallen
ursday, August 12, 2010 8:24 PM > To: 'u2-users@listserver.u2ug.org' > Subject: [U2] Unix to SQLServer > > In the dying months of our major application, we are looking at sending > small amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer > database every few m

Re: [U2] Unix to SQLServer

2010-08-13 Thread Barry Rutherford
Free: 800-786-8015 x 6162 Fax: 443-662-4225 http://www.mobilexusa.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Thursday, August 12, 2010 8:24 PM To: 'u2-users@listserver.u2ug.o

Re: [U2] Unix to SQLServer

2010-08-13 Thread Brian Leach
users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unix to SQLServer In the dying months of our major application, we are looking at sending small amounts of data f

Re: [U2] Unix to SQLServer

2010-08-13 Thread Symeon Breen
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unix to SQLServer In the dying months of our major application, we are looking at sending small amounts of data from UniVer

Re: [U2] Unix to SQLServer

2010-08-13 Thread John Woollam
Perkins PLC | UK | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unix to SQLServer In the dying

Re: [U2] Unix to SQLServer

2010-08-13 Thread Mecki Foerthmann
Why not use SSIS if you want to transfer data into SQL Server? Norman, David (Health) wrote: > In the dying months of our major application, we are looking at sending small > amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer database every > few minutes from a phantom. I assume ODBC

Re: [U2] Unix to SQLServer

2010-08-12 Thread Bill Brutzman
-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) [david.nor...@health.sa.gov.au] Sent: Thursday, August 12, 2010 8:24 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unix to SQLServer In the dying months of our major application, we are looking at sending small amoun

[U2] Unix to SQLServer

2010-08-12 Thread Norman, David (Health)
In the dying months of our major application, we are looking at sending small amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer database every few minutes from a phantom. I assume ODBC would be the way to go, with middleware from someone. Which middleware do people recommend ? Is th