Re: JSP connection to database problem

[Lance Lavandowska]

Title: JSP connection to database problem

Check out DBTags at jakarta.apache.org/taglibs   It has support for stored procedures (I believe) and should greatly simplify what you are trying to do.   Lance ----- Original Message ----- From: Bruce Wexler To: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 8:05 PM Subject: JSP connection to database problem Hello, I am using a database connection (conn1) in my JSP include page which is connecting to the first (SQL 7) database with a stored procedure. The stored procedure is performing a query which utilizes tables in another database on the same server. I have also tried to use a second database connection, and an inline query, but still get an error. Can someone please tell me what I am doing wrong? Is it even possible to do this with JSP? I've been able to use two databases in ASP, so I wasn't sure about making this work in JSP. Below is the JSP page and stored procedure. TIA, Bruce Wexler Programmer/Analyst