Skip to Content
avatar image
Former Member

Picking the data from MS-Access Database

Hi Guys,

I have the requirement where i need to pick the data from MS-Access Database, Can anybody tell me the required parameters which we need to pass for the JDBC Adapter, especially the Parameters 'Drivers' and 'Connection'.

Any help is appreciated.

Thanks in Advance.

Regards,

Kittu.

Message was edited by: kittu chowdary

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 08, 2006 at 09:43 AM

    Hi,

    Check on this weblog:

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

    Regards

    Vijaya

    Add comment
    10|10000 characters needed characters exceeded

    • hi Kittu,

      just check the path specified once again.

      try using this

      JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

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

      if there is any username and password also specify it as in weblog.

      Regards

      Sachin

  • avatar image
    Former Member
    Nov 08, 2006 at 09:50 AM

    Hi,

    As well you have to Deploy the JDBC Driver for MS-Access Database.

    How" target="_blank">https://websmp209.sap-ag.de/~form/sapnet?_SHORTKEY=01200252310000071155&">How to Install and Configure External Drivers

    regards,

    Robin

    Add comment
    10|10000 characters needed characters exceeded