Skip to Content
avatar image
Former Member

Problem when connecting to MS Access through JDBC Adapter.

Hello,

I am trying to connect to MS access through JDBC adapter.

Can you please tell me the appropriate driver name and URL to connect the local MS Access DB to process teh data.

I am on SOLORIS machine with jdk 1.4 installed on it.

Thanks,

Soorya.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 12, 2008 at 08:21 AM

    1. you dont need to deploy any additional JDBC drivers to access MS-ACCESS.

    JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

    Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\demo.mdb

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      HEllo,

      I have used these details to configure a scenario with Ms Access through JDBC adapter.

      URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/XI/Workspace/xi_input.mdb

      Jdbc Driver: jdbc.odbc.JdbcOdbcDriver

      or

      URL: jdbc:odbc:<DSN Name>

      Jdbc Driver :sun.jdbc.obc.JdbcOdbcDriver

      Thanks,

      Soorya

  • avatar image
    Former Member
    Feb 06, 2008 at 10:58 AM

    Hi,

    Correction made by me as said by Prateek. No JDBC driver required.

    Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

    Thnx

    Chirag

    Edited by: chirag Gohil on Feb 6, 2008 4:57 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      please tell me the exact URL and Driver if i want to test it my local machine,

      jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb

      my .mdb file is in C:/XI/Worksapce/

      thanks ,

      Soorya

  • avatar image
    Former Member
    Feb 06, 2008 at 11:03 AM

    Surya, what error are you getting?

    Peter

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 06, 2008 at 11:06 AM

    Hi surya,

    Please check the driver path as mentioned below.

    JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

    Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

    Regards

    mahesh.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I am having my MDB file in local machine at c:/xi/workspace.

      And in the URL if i give like,

      jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//<IP_ADDRESS> or <MACHINE_NUMBER>/C:/XI/WORKSPACE/XI_INPUT.mdb;

      can you please help me out in giving the correct URL format to execute the scenario.

      Thanks,

      SOORYA