Arthur, If you're up to it, have a look at using the IIS interface & SQLXML. If you are using a release of U2 which supports http functions then there's nothing to install on the U2 side. It basically just needs to have the interface set up under SQL.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/intro_3tbm.asp Data can be retrieved as easily as: url = 'http://sqlsvr/u2source'?SQL=select%20*%20from%20mytable%20for%20xml%20auto' crt createRequest(url,'GET',sessionHandle) crt submitRequest(sessionHandle,10000,'',httpHeaders,response,httpStatus) *// optionally use the u2 xml functions or hard-parse the returned xml in "response". It's pretty efficient too. A quick test on a sql server sitting on the other side of our DMZ took 3 minutes to write a program and 2.5 secs to return 10mb of data. Cheers, Stuart -----Original Message----- "Metherall, Arthur" Hello, Is anyone using a unix ODBC driver, other than DataDirect, that can be installed onto an AIX box that will connect to MS-SQL 2000? I need to pull information from the MS-SQL 2000 database into my UniData environment for reporting using BCI. ********************************************************************** 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
