access Access 2000 vio jdbc-odbc bridge ?? code

[christian ruediger]

Hi,
i guess my problem is quite simple but i failed to get it solved:
The system data:
Win 2K
Access 2000
odbc: Microsoft Access Driver (*.mdb) Version : 4.00.6200.00
SDK 1.4.1
Tomcat 1.4
I have tried to connect to MS Access through jdbc:odbc Bridge. The Code
looks as follows:
(using jsp)

<%@ page import="java.sql.*" %>

<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc:odbc:Microsoft Access Driver (*.mdb);"+
"DBQ=C:/foo.mdb;";

Connection con = DriverManager.getConnection(url,"","") ;
%>

The error-message is the following:

javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:471)
at org.apache.jsp.akzeptiert$jsp._jspService(akzeptiert$jsp.java:146)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at
org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:
1027)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125
)
at java.lang.Thread.run(Thread.java:536)
Please HelpThanx Christian Rüdiger

[Axel Hallez]

String url = "jdbc:odbc:DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=c:\foo.mdb";

Axel Hallez

[christian ruediger]

"Axel Hallez" <axel....@rug.ac.be> wrote in message
news:<aqr0dk$sh7$2...@newsreader.mailgate.org>...

> String url = "jdbc:odbc:DRIVER={Microsoft Access Driver

> (*.mdb)};DBQ=c:\foo.mdb";

>

> Axel Hallez

>

>

Thanx for your reply.

I solved my problem by adding my DB to ODBC-datasources.

Here is how to do that in win 2000:

1. click Start->settings->control panel->Administrative tools->Data sources
(odbc)

2. in ODBC Data Source Administrator click [Add...]-button

3. choose MS-Access Driver and click [Finish]

4. write a favoured name for your db into the [Data Source Name] field

5. in the Database section click [Select...]-button and browse for your
database. click [OK]

6. click [OK]. by now your Database should be in the list of User Data
Sources. click [OK]

if you want to connect to your DB the java code is:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc:odbc:yourChosenDbName";

Christian Ruediger