If you're not going to dump a flat file and let the SQL server do the import you might want to look at Easysoft. We're using Easysoft's ODBC driver and rather than trying to integrate it into Universe, we're using the isql command that comes with it. The isql command is a UNIX command that works with their ODBC driver. You just have to create a couple of config files under /etc and make some modifications to your .profile so you can run the command. Just have your Universe program build a script containing the SQL command then execute the isql command to run the script as a batch. You capture the results of the execute statement and examine them to make sure it was successful. It's simple and Easysoft isn't very expensive.
Barry Rutherford Programmer / Analyst MobilexUSA 930 Ridgebrook Rd, 3rd Floor Sparks, MD 21152 Local: 443-662-4101 x 6162 Toll 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.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 minutes from a phantom. I assume ODBC would be the way to go, with middleware from someone. Which middleware do people recommend ? Is there any which doesn't require UniVerse to be stopped to install ? I looked on the Wiki but didn't find anything about this. Thanks, ======================== David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * david.nor...@health.sa.gov.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail (including any and all accompanying attachments) may contain privileged and confidential information only meant to be accessed and used by the intended recipient or the person(s) authorized to access and deliver the intended recipient's e-mail. This e-mail may contain information that is privileged or otherwise confidential. It should not be copied or forwarded to any unauthorized persons. If you received this e-mail in error, please delete it without copying or forwarding, and notify the sender by reply e-mail or by calling the MobilexUSA Privacy Office toll free at 1-866-686-1717. Thank you for your cooperation. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users