what is the Name of the Driver , which i Should use for MS-ACCESS DB???????

[Former Member]

Hi ,

What is the Name of the MS-ACCESS Driver to Connect MS-ACCESS DB( A MS-OFFICE Product) and SAP PI 7.0 ???????

Give me the name of driver?

Giive me the name of Web-Site/exact path from where can i download these drivers for free.??

or If you can provide me the Direct Driver jar file. Send it to me ????

I am using SAP - PI 7.0 Version

Regards

PS

[rajasekhar_reddy14]

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&dis...

[Former Member]

Regards

PS

[Former Member]

Hi Raja ,

I have clicked on ur given link and one .exe file is downloaded.'

after click on ( AccessDatabaseEngine.exe ), it is installed ...

1. Do i have to execute this AccessDatabaseEngine.exe file on SAP-XI/PI Server ????????????

2. Will it automatically install / Deploy the Drivers on this path on XI / PI Server ???????????????????

3.

3.1Creating or Getting aii_af_jmsproviderlib.sda

3.2Getting an Existing aii_af_jmsproviderlib.sda

3.3 Creating an Empty aii_af_jmsproviderlib.sda

3.4 Adding Driver JARs to aii_af_jmsproviderlib.sda

3.5 Deploying aii_af_jmsproviderlib.sda on the J2EE Engine

will all these steps 3.1 to 3.5 need not to be performed, If we exceute your suggested AccessDatabaseEngine.exe file?????

Regards

PS

[Former Member]

Hi,

JDBC Driver to be used is: jdbc.odbc.JdbcOdbcDriver

Please refer the following blog:

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

Regards,

Gaurav.

[Former Member]

Hi gaurav , I have already followed this blog ...

according to this i have not deployed/installed any driver on XI Server ..

Nor I have maintained any ODBC-DataSource in admin-Control panal ...

I just maintained Ccommunication Channel , after looking at This Blog ..

and I am getting errors....

So Now I am Confused , Do i really have to Delpoy Drivers and maintain ODBCDatasource ????/

i need help ...

I am Stucked ..

Regards

PS

[Former Member]

Hi,

in the system where u have ur MSAccess DB, there in Program Files in MS Office in MSAccess there may be a bin or lib folder...... just open this library folder, there u may find its driver file....it can be a jar file with name having sql something.......or may be ur MSAccess DB administrator can help u to locate ur MSAccess driver file.........