on 02-06-2008 10:57 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Surya, what error are you getting?
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.