Results 1 to 3 of 3
  1. 10-24-2011, 08:25 PM #1
    kkji
    kkji is offline Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    0

    Default which one is better and why?

    for connecting ms-access
    DriverManager.getConnection("jdbc:odbc:Driver={Mic roSoft Access Driver (*.mdb)};DBQ=database.mdb");
    above line is good or below line
    DriverManager.getConnection("jdbc:odbc:Driver:dsnn ame",""."");
    Reply With Quote Reply With Quote
  2. 10-24-2011, 11:29 PM #2
    kkji
    kkji is offline Member
    Join Date
    Aug 2011
    Posts
    54
    Rep Power
    0

    Default Re: which one is better and why?

    for me DriverManager.getConnection("jdbc:odbc:Driver:dsnn ame","".""); works fine but not able to execute the other one.
    Reply With Quote Reply With Quote
  3. 10-25-2011, 08:17 AM #3
    masijade
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,366
    Rep Power
    7

    Default Re: which one is better and why?

    You want to use the dsnless whenever possible as it at least takes you step further away from external odbc configurations that have to be done in order to even use the code.
    Reply With Quote Reply With Quote
« JCheckBox | ERROR WHILE TRYING TO CONNECT MySQL( javax.naming.NameNotFoundException) »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules