Read or update? Doesn't matter, my experience is using SQL XML on SQL 2K. We use http from UniVerse to update MSSQL with "updategrams" (an MS term). It works well, no need to install anything that wasn't already installed. Works across port 80 &/or 443 through our firewalls.
Not as fast as but reasonable performance compared with ODBC et al. Convenience overrides. You need MS SQL 2000 with IIS configured with support for SQL XML. On the UV side we just use 'EXECUTE "LIST ... TOXML" CAPTURING XML.UPDATE.DATA' to generate the XML updategrams but I understand recent versions of UV have improved support for generating XML in basic. There are risks using that method as large amounts of data in the capturing variable could blow your workspace. You can also use IIS SQL XML support to read (XML) data from MSSQL. Regards, Stuart -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Yang, Songying, JIMS" <[EMAIL PROTECTED]> Sent: Tuesday, 26 July 2005 02:04 To: <[email protected]> Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ********************************************************************** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ********************************************************************** ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
