cancel
Showing results for 
Search instead for 
Did you mean: 

Problem when connecting to MS Access through JDBC Adapter.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (3)

Answers (3)

former_member859847
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

Surya, what error are you getting?

Peter

Former Member
0 Kudos

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

prateek
Active Contributor
0 Kudos

No JDBC Driver deployment is required for MS access. Directly follow the weblog provided

Regards,

Prateek

Former Member
0 Kudos

I dont think so, your XI is not installed on Window platform. so Drivers need for this

thanks

farooq.

Former Member
0 Kudos

Hi!

Farooq: There shoud be default driver available after installtion on unix too.

We experience some problems with this adapter too. Can you please write the complete errror message?

Peter

Former Member
0 Kudos

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