JDBC-File Error -'Data source name not found, and no default driver specif'

[Former Member]

Hi All,

We are trying for JDBC to File Scenario. I have configured JDBC adapter by referng blog

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

But I am getting following error in communication channel monitoring

<i>Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=
root\JDBC\Employee.mdb' using the JDBC driver 'sun.jdbc.odbc.JdbcOdbcDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=
root\JDBC\Employee.mdb': SQLException: [unixODBC][Driver Manager]<b>Data source name not found, and no default driver specified</b>'</i>

Actually my XI server is installed on Linux Operating system.. so I have asked basis guy to put .mdb file on XI server. He has put file in folder named JDBC

Do I have to install any JDBC driver on linux sys to make it work?

Please tell me where I will get this server

Any help appriciated

Thank you

Mugdha Kulkarni

[Former Member]

Hi

Access does not require any drivers.It takes it from the system.Check the Connection string.

Thanks

[Former Member]

Hi Monika,

<i>Access does not require any drivers.It takes it from the system.</i>

-->I guess that is right if XI server is running on Windows.Please correct me if I am wrong.

In my case, how should connection string look like?

At present it is

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=
root\JDBC\Employee.mdb

[Former Member]

Hi Mughda,

Any update on this thread..

My XI server is on windows ..yet I get the same error

Regards,

Teja

[former_member190313]

hi

this problem is appearing as XI is getting the path of .mdb file .

u are giving the path : \root\JDBC\Employee.mdb

remove \root as well and give relative path of JDBC.

it should work

Sheetal

[Former Member]

Hi Sheetal,

I tried removing tht. But did not work.

My XI server is on linux and i am trying to put .mdb file on that..

Is that a problem?

Do I have to install any kind of driver on linux server?