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

Problem while connecting to MS Access 2007

Received	by 10.66.83.74 with SMTP id o10mr1970232pay.33.1346497490718; Sat, 01 Sep 2012 04:04:50 -0700 (PDT)
MIME-Version	1.0
Received	by 10.68.197.70 with SMTP id is6mr2412025pbc.14.1346497490690; Sat, 01 Sep 2012 04:04:50 -0700 (PDT)
Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!nntp.club.cc.cmu.edu!newsfeed.news.ucla.edu!usenet.stanford.edu!4no1793947pbn.1!news-out.google.com!a8ni4210pbd.1!nntp.google.com!4no1793944pbn.1!postnews.google.com!rq1g2000pbb.googlegroups.com!not-for-mail
Newsgroups	comp.lang.java.databases
Date	Sat, 1 Sep 2012 04:04:50 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	rq1g2000pbb.googlegroups.com; posting-host=203.201.222.196; posting-account=UzevbQoAAABu6FGaSl5tpeOJ7IcNa6Ko
NNTP-Posting-Host	203.201.222.196
User-Agent	G2/1.0
X-HTTP-Via	1.1 TTPNEPXY02
X-HTTP-UserAgent	Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0; GTB7.0),gzip(gfe)
Message-ID	<d34c0003-ddab-4e7d-89ad-5d4f722ca132@rq1g2000pbb.googlegroups.com> (permalink)
Subject	Problem while connecting to MS Access 2007
From	ruds <rudranee@gmail.com>
Injection-Date	Sat, 01 Sep 2012 11:04:50 +0000
Content-Type	text/plain; charset=ISO-8859-1
Xref	csiph.com comp.lang.java.databases:556

Show key headers only | 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