File to JDBC error

[Former Member]

HI,

I'm doing file to jdbc scenario.

I gave the connection path as

{Microsoft Access Driver(*.mdb)};DBQ=//hstxid/XITEST1/file2jdbc/rec.mdb

In Runtime workbench it is giving the error as

Attempt to establish database connection failed with SQL error Unable to locate a suitable JDBC driver to establish a connection to URL '{Microsoft Access Driver(*.mdb)};DBQ=//hstxid/XITEST1/file2jdbc/rec.mdb'

Delivery of the message to the application using connection AFW failed, due to: Database connection could not be established.

Can u please tell me if the error is in creating the table in MSAccess or anyother , as the structure of the table is same as i have given in xi.

[Former Member · Accepted solution]

hi

first of all install the drivers in the system..then it will locate the drivers..

[Former Member]

Thanks for providing me the information for installing jdbc drivers.

Divya

[Former Member]

Hi

First of all you do not need to install any drivers for MS Access and then check your connection path.

Regards

Monika

[Former Member]

Hi

first deploy JDBC driver provided by your vendor

athen check your data base connection you must have admin rights for this

Then you wil be able to connect to your data base

regards

sandeep

If helpful reward points

[Former Member]

Hi,

Check if any user Authentication required to access the Ms access table

try this

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//xiserver/xitemp/db/TestDB.mdb;Uid=yourid;Pwd=yourpwd;

Also check whether your mdb file is on same host. If it might e on different host it may unable to connect.

Thanks

Swarup

[Former Member]

Hi,

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

We have to mention the following details in case of Ms-Access-XI

URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/XI/Workspace/xi_input.mdb

Jdbc Driver: jdbc.odbc.JdbcOdbcDriver

or

URL: jdbc:odbc:<DSN Name>

Jdbc Driver :sun.jdbc.obc.JdbcOdbcDriver

Regards

Seshagiri

[Former Member]

Hi,

The path for the guide which you have mentioned for installing the Access Driver is not getting opened.

Could you please provide me the same again.

Thanks.