on 03-26-2009 2:54 PM
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,
it's solved!
CALL FUNCTION 'XXXX' IN BACKGROUND TASK...
in background task was necesry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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á
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
thanks
PD:points if useful
Rodrigo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
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.