> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG > Sent: Friday, May 09, 2008 1:32 PM > To: [email protected] > Subject: RE: [U2] U2 - SQL Server ODBC Connection via Universe > > There is also Easysoft which seems to be a good one. I've > tested it but have > not put it into production yet. > There seems to be more action being done at getting things from the U2 > environment then the other way around. What we are doing here > is the other > way around, trying to get data from SQL Server for use with > our UV programs. > > Jerry Banker > Senior Programmer Analyst > IBM Certified Solutions Expert
Just a word of caution - I tested Easysoft's ODBC driver last year when we migrated from SQL 2000 to SQL 2005 (it looked like there was a slight cost advantage over OpenLink until I discovered Easysoft charges for each client node in a linux HA cluster). The Easysoft driver worked fine for our daytime transaction processing that involves sending and/or retrieving 5-10 records every few minutes. When I tested our nighttime batch processing, however, which sends as many as 35K records across all at once, the SQL 2005 box would spiral down to the point it was unresponsive and in-turn cause UV to crash. I was able to dig up my email to Easysoft support, and this is what I saw from the UV side: 31268 record(s) selected to SELECT list #0. CR0013: SQLExecDirect failed, error condition SQLSTATE: 08S01, DBMS.CODE: 0ERROR: [IBM][SQL Client][ODBC][unixODBC][Easysoft][ODBC-SQL Server Driver][SQL Server]Communication link failure: socket read failed CRITICAL ERROR! Notify the system administrator. Abnormal termination of UniVerse. Fault type is 13. Layer type is Verb. Broken pipe The process would make it through about 15K records before the SQL box was completely unresponsive. This was in Oct. of '07, so the problem may have been corrected by now, but I highly recommend you do tests with heavy transaction loads. -John ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
