Thanks David, I suppose we assumed as many would that an OLEDB driver would handle concurrent requests especially when the documentation talks about UniOLEDB's support for free threading.
Frustrating as hell, looks like we will move to a SQL Server caching solution. I have the theory of bidirectional sync in my head, triggers from SQL populating Unidata and I'm thinking about triggers from Unidata populating a control table which SQL polls. Not sure if the Unidata -> SQL can be done in a more efficient manner. Funny enough the first response from IBM was to use their "wonderful" redback product instead. Thanks Nick -----Original Message----- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: 12 February 2004 04:24 To: 'U2 Users Discussion List' Subject: RE: UniOLEDB Threading issue Ah, if only you had asked the list (or check the archives), before you started...someone would've let you know about this 'feature'. Both U2 products have this same feature, IIRC. Lots of others have found out the hard way too. Many have gone the way of connection pools or some other middleware. IBM would like you to use Redback, which is their official 'middleware' for U2 products. There are stacks of postings in the online archives, which discuss what your after. Some are useful, like this... http://www.indexinfocus.com/dl/u2list/200303/47846.html Although this article talks about UV, some of the concepts may also be applicable to UD... http://www.indexinfocus.com/dl/u2list/200007/1913.html Regards David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Southwell Sent: Thursday, February 12, 2004 2:13 AM To: U2 Users Discussion List Subject: UniOLEDB Threading issue Using Unidata 5.1 on AIX. We've developed a web based application which uses UniOLEDB to read/write from Unidata. After a lot of hair pulling we've discovered that although the OLEDB provider appears to thread correctly the udsrv process on Unidata serialises all requests. This has effectively left us with an application that supports one concurrent user! Just wondered if anyone else had experienced similar issues, I opened a case with IBM to be told it won't be fixed in the near future. Looking at a complete rewrite with Raining Data's Pick Data Provider. Anyone using it? Thanks Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at Royston House, 34 Upper Queen St, Belfast, BT1 6FA -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users