October 22, 2009 at 2:18 pm
You're describing exactly what we had to do in an app we wrote a few years ago. We had a .net service that monitored the queue and pulled the xml out of websphere and passed it to SQL Server. In sql I think we used openxml to open the document up and consume it. Make sure you destroy your the document within sql when you're done as you'll end up with a collasal memory leak if you don't.
October 22, 2009 at 3:07 pm
Mike, that's very helpful. Thank you.
So, there's no "inside-SQL 2000" way of doing this, I gather.
Would you be open to selling the .NET source code (priced so as to be royalty-free, and I'll assume responsibility for anything that screws up) for me to use as a basis for my own app?
Regards,
Andre Gous
Founder, CEO, Chief Geek
Precision Quality Software, Inc.
Divisions include:
FallonWebSites.com
NevadaPaperless.com
October 23, 2009 at 8:45 am
Let me see if I can dig that code up. I've since switched jobs but might have saved a copy. If not I can get in touch with someone else who might have it. Please send me an email and we can work on this outside of the forum.
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply