Skip to Content
0
Former Member
Apr 22, 2010 at 06:15 PM

Unable to locate a suitable JDBC driver to establish a connection to URL

49 Views

Hi experts,

I have developed an interface IDOC to JDBC (MS ACCESS) but when try to deliver the message in the MS ACCESS I get this error in the communication channel:

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//10.YY.YY.10/XXXX/XXXXX/pdddd.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Unable to locate a suitable JDBC driver to establish a connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=//10.YY.YY.10/XXXX/XXXX/pdddd.mdb''.

The parameters of the Communication channel are:

Driver: sun.jdbc.odbc.JdbcOdbcDriver

Conection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//10.YY.YY.10/XXXX/XXXX/pdddd.mdb

In my local (windows) I have developed a litlle java code to check the connection with the ms access, I was fine. I'm in the same network that PI.

I don't know if the JdbcOdbcDriver is compatible with UNIX or I would need a diferent driver to connect. What driver connect PI and MS Access?

Any idea?

Thanks in advance.

Jose