cancel
Showing results for 
Search instead for 
Did you mean: 

Access to Database Access from JDBC

Former Member
0 Kudos

Hello,

I have a RFC to JDBC scenario.

The database is on a different machine to the XI, but from XI is going to map a drive to see the database.

In the communication channel I specified the drive with the rest of the path:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Z:/TestDB.mdb

and I get an error:

com.sap.aii.af.ra.ms.api.DeliveryException: Database connection could not be established

Is it possible to access an Access database that is not physically in the machine XI?

thanks very much,

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

it's solved!

CALL FUNCTION 'XXXX' IN BACKGROUND TASK...

in background task was necesry

iprieto
Contributor
0 Kudos

Hello Silvia,

You must to configure and install the JDBC driver before use the communication channel. For do it, the first is download the JDBC class for your Database, in yous case you must to download MSQL jdbc class http://msdn.microsoft.com/en-us/data/aa937724.aspx.

Second, you must to create a sda file for deploy in J2EE, for do it check : https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60237e74-ef19-2b10-5a9b-b35cc6a2....

Best regards

Ivá

rodrigoalejandro_pertierr
Active Contributor
0 Kudos

hi silvia

first, you need to install JDBC driver in PI to be able to connect to MS Access.

please, see these links

https://forums.sdn.sap.com/click.jspa?searchID=24103238&messageID=7100823

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

thanks

PD:points if useful

Rodrigo

Former Member
0 Kudos

Hi,

First of all you have to install the data base drivers in XI. Then just configure your JDBC adapter as it is explained in SAP HELP documentation.

Regards

Gonzalo