This post is targeted at anyone who is currently using/developing JSP/Servlets with Allaire's JRUN 3.1 's tag library and AveConnect's version 2.5 JDBC driver for SQLServer 2000.
I've been working with Allaire to try and determine why their new Stored procedure tag in the JRUN 3.1 tag library fails when used with AveConnect's version 2.5 JDBC driver. If you are developing with these two pieces of software, then you may be interested in this info. The AveConnect driver can return in/out and out parameters from a SQLServer 2000 stored procedure in "different placeholders" than the order (or placeholder) it is sent to the stored procedure. If this occurs, the JRUN stored procedure tag in the JRUN 3.1 stored procedure tag library will throw an error within JRUN's tag library itself, as the servlet behind this tag looks for the returning in/out parameter value in the same "placeholder" it was sent to the stored procedure in. If you are running into this problem, and are interested in the resolution and/or discussion thread, you can go to http://webforums.macromedia.com/jrun/messageview.cfm?catid=66&threadid=24445 4 I have found two ways to "kinda sorta" work around this issue and still use the tag library, but the JSP/Servlet code is very touchy and not what I would refer to as "robust". If you are in the position of having or wanting to use this tag library (vs. writing your own stored procedure tag) with this driver, and are interested in seeing this code, please post a note at the above forum thread, and I will email the code to you. Celeste =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
