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. Simple.

Re: [U2] Unix to SQLServer

2010-08-17 Thread George Gallen
: 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 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

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

Re: [U2] Unix to SQLServer

2010-08-14 Thread JPB-U2UG
Subject: Re: [U2] Unix to SQLServer 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

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-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 months

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 UniVerse 10.0.16

Re: [U2] Unix to SQLServer

2010-08-13 Thread Brian Leach
...@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 UniVerse 10.0.16

Re: [U2] Unix to SQLServer

2010-08-13 Thread Barry Rutherford
: 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.org' Subject: [U2] Unix to SQLServer

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

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

Re: [U2] Unix to SQLServer[AD]

2010-08-13 Thread Robert Houben
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 Three options really 1. BCI

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 out

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

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

[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

Re: [U2] Unix to SQLServer

2010-08-12 Thread Bill Brutzman
...@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 amounts of data from