Groups > comp.lang.java.databases > #556

Problem while connecting to MS Access 2007

Newsgroups	comp.lang.java.databases
Date	2012-09-01 04:04 -0700
Message-ID	<d34c0003-ddab-4e7d-89ad-5d4f722ca132@rq1g2000pbb.googlegroups.com> (permalink)
Subject	Problem while connecting to MS Access 2007
From	ruds <rudranee@gmail.com>

Show all headers | View raw

Hi, I'm getting " Data source name not found and no default driver
specified" Error while connecting to MS Access database through
tomcat. I have  created user DSN for my db.
My connection code is:
 Connection con =null;
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String conStr = "jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb, *.accdb)};DBQ=" +
            "D:\\OLD D DRIVE\\FileManager\\FileManager.mdb";
        con = DriverManager.getConnection(conStr);
    } catch(Exception e) {
        e.printStackTrace();}

Back to comp.lang.java.databases | Previous | Next — Next in thread | Find similar

Thread

Problem while connecting to MS Access 2007 ruds <rudranee@gmail.com> - 2012-09-01 04:04 -0700
  Re: Problem while connecting to MS Access 2007 Arne Vajhøj <arne@vajhoej.dk> - 2012-09-01 10:19 -0400
    Re: Problem while connecting to MS Access 2007 ruds <rudranee@gmail.com> - 2012-09-02 22:45 -0700
      Re: Problem while connecting to MS Access 2007 Arne Vajhøj <arne@vajhoej.dk> - 2012-09-03 22:34 -0400
        Re: Problem while connecting to MS Access 2007 ruds <rudranee@gmail.com> - 2012-09-03 22:02 -0700
          Re: Problem while connecting to MS Access 2007 Arne Vajhøj <arne@vajhoej.dk> - 2012-09-06 20:41 -0400
            Re: Problem while connecting to MS Access 2007 ruds <rudranee@gmail.com> - 2012-09-06 20:32 -0700
              Re: Problem while connecting to MS Access 2007 Arne Vajhøj <arne@vajhoej.dk> - 2012-09-08 18:01 -0400
  Re: Problem while connecting to MS Access 2007 Roedy Green <see_website@mindprod.com.invalid> - 2012-09-06 16:22 -0700

csiph-web