Accessing MS Access Database

[Former Member]

Hi All,

I have some doubts regarding accessing MS Access Database.

I am using JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection String : jdbc:odbc:Driver ={Microsoft Access Driver (.mdb)};DBQ=
ABC\Wegsoft.mdb*

1. Do I need to deploy any Driver file in PI Server? if yes then which one?

2. Do I need to define DSN? and where I have to define in PI Server or third party database server?

3. Does driver Microsoft Access Driver (.mdb)* need to be present on PI Server?

4. And what are the other setting I need to do?

Thanks & Regards,

RP

[Former Member]

Hello,

my problem is similar, I can not access a DB that XI is not in the XI server,

do you solve the problem? Did any SAP solution? Could you please share?

Thanks very much,

[Former Member]

Hi,

SAP had requested System Service pack details we provided that and they replied that JAVA and ABAP stack are not at same level.

-RP

[Former Member]

Have raised message to OSS and waiting for reply!!!!!!!!!!!!

[Former Member]

You don't need to do this,

Just use jdbc.odbc.JdbcOdbcDriver

greets

[Former Member]

ya thats ok but it throughs me following error:

SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

I will be thanksfull if somebody provides answers to all my questions.

Thanks & Regards,

RP

[former_member206760]

If your XI is on windows platform no driver is required...

check that the table structure and the source data type that you have creted is proper like ....field sequence..CAPS or not etc

also try using sun.jdbc.odbc.JdbcOdbcDriver instead of odbc.JdbcOdbcDriver

Edited by: Tarang Shah on Feb 25, 2009 11:07 AM

[Former Member]

I am getting following error:

Error during database connection to the database URL 'jdbc:odbc:Driver ={Microsoft Access Driver (.mdb)};DBQ=//134.137.21.50/wbs/Wegsoft.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver ={Microsoft Access Driver (.mdb)};DBQ=//134.137.21.50/wbs/Wegsoft.mdb': SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

Please suggest.

Thanks,

RP

[Former Member]

Dear All,

I am looking for the answers to following Questions.

1. Do I need to deploy any Driver file in PI Server? if yes then which one?

2. Do I need to define DSN? and where I have to define in PI Server or third party database server?

3. Does driver Microsoft Access Driver (.mdb)* need to be present on PI Server?

4. And what are the other setting I need to do?

Currently i am getting an error:

Error during database connection to the database URL 'jdbc:odbc:Driver ={Microsoft Access Driver (.mdb)};DBQ=//134.137.21.50/wbs/Wegsoft.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver ={Microsoft Access Driver (.mdb)};DBQ=//134.137.21.50/wbs/Wegsoft.mdb': SQLException: MicrosoftODBC Driver Manager Data source name not found and no default driver specified'

Please suggest.

RP

[Former Member]

RP,

I think there may be an error in your URL. There should not be a space (' ') between Driver and =. You could also try using backslashes. This will result in:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=\\134.137.21.50\wbs\Wegsoft.mdb

Kind regards,

Koen

[Former Member]

Koen,

Thanks for the reply and pointing my mistake.

But it's not working still.

Can you tell me is it looking for ODBC or JDBC Driver?

Also do I require to define DSN anywhere? If yes then on which system?

Thanks & Regards,

RP

[Former Member]

Dear All,

Can anebody answer my queries.

I am looking for the answers to following Questions.

1. Do I need to deploy any Driver file in PI Server? if yes then which one?

2. Do I need to define DSN? and where I have to define in PI Server or third party database server?

3. Does driver Microsoft Access Driver (.mdb)* need to be present on PI Server?

4. And what are the other setting I need to do?

Thanks & Regards,

RP

[Former Member]

Hi, RP:

Your questions have been asked in previous thread, and Bhavesh has given answer in following thread:

Therefore, for MS ACCESS database, it is not required to deploy jar driver file like other database.

(your third question is answered here as well)

For the database connection, you can use DSN less connection, refer to the link posted by Tarang Shah.

If you keep coming cross the error, search SAP notes to see if you get any hints.

Regards.

Liang

[former_member206760]

You do not need to install drivers for MS Access.

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

You use jdbc.odbc.JdbcOdbcDriver