Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > ODBC Bridge Connections From JSP Help

Reply
Thread Tools

ODBC Bridge Connections From JSP Help

 
 
Robert Nurse
Guest
Posts: n/a
 
      11-11-2003
Hi All,

I'm just learning JSP and I've run into a problem. I'm trying to get
a database connection for a login page I've created using Jakarta's
DBTag library. I configured the ODBC data source (proj3odbc) on the
box that Tomcat 5.X runs on. The DBMS, however, runs on another box.
I've verified that the datasource works. The user name is userxxx and
the password is ASECRET. Here's my JSP connection code:

// Make database connection via the Sun ODBC Bridge
<sql:connection id="dbCon">
<sql:url>jdbcdbcroj3odbc:userxxx:ASECRET</sql:url>
<sql:driver>sun.jdbc.odbc.JdbcOdbcDriver</sql:driver>
</sql:connection>

But I keep getting:

javax.servlet.ServletException: java.sql.SQLException:
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:673)
org.apache.jsp.LoginPage_jsp._jspService(LoginPage _jsp.java:313)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:24
javax.servlet.http.HttpServlet.service(HttpServlet .java:856)


Any ideas as to what the problem could be?

TIA
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bridge/workgroup bridge scenario and channels Chris_D Cisco 6 08-05-2005 07:46 AM
Where can I get a free JDBC-ODBC bridge? Dave Stallard Java 4 11-12-2004 11:10 PM
Re: Is There Free Alternate To JDBC-ODBC Bridge In JDK Dave Glasser Java 5 08-27-2003 08:32 PM
Problems with Sun's JDBC-ODBC bridge Berboris Java 0 07-01-2003 02:50 PM



Advertisments