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 Denver. Try Q00178, Q00179, Q00180 , Q00182 - Q00187. HTH Mike > -----Original Message----- > From: [EMAIL PROTECTED] On Behalf Of Nick Cipollina > Sent: Friday, 3 February 2006 10:41 > To: u2-users@listserver.u2ug.org > Subject: [U2][UV] Universe and SQL Server > > Hello all, > > 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 scheduler that picks up > the files when they arrive and inserts them into SQL server. > I know there are ways to communicate directly between SQL > server and Universe and I am looking for the best way to do > this. It doesn't matter if Universe reaches out to SQL > Server or vice versa. Thanks. > > Nick Cipollina > > Pick Programmer > ACS Heritage, Inc. > 2810 North Parham Road, Suite 210 > Richmond, VA 23294 > (804)644-8707 x 314 > > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/