Unable to connect to sender JDBC, MS Access database

[Former Member]

Hi Experts,

Im trying a JDBC to file scenario.

For MS access i used this blog by sameer

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417600)ID2049577050DB10280406367666984907End...

In sender communication channel..I get this error

Error during database connection to the database URL 'jdbc:odbc:Driver={Microsoft Access Driver (.mdb)};DBQ=/usr/sap/trans/pi/PI_Table1.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=/usr/sap/trans/pi/PI_Tauseef1.mdb': SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified'

Can ne one pls help me out...

Am i missing out something?

Regards,

Teja

[Former Member]

Hi Ravindra,

if your database is remote, make sure it is visible from the machine XI (if not, you should map the drive)

regards,

[former_member187339]

Hi Ravindra,

Have you deployed the necessary drivers to SAP PI?

Check the note Note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Regards

Suraj

[Former Member]

Hi Guys,

I am of the opinion that for MS Access we dont need to deploy any drivers..am i right?

[former_member187339]

Hi,

Note 831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/70ffd890-0201-0010-708f-d5dad2dfcf3a&override...

If you have aii_af_jmsproviderlib.sda deployed you should have the needed drivers

Regards

Suraj

[Former Member]

Hi ,

I see aii_af_jmsproviderlib.sda on visual admin

I did the mark slected as JDBC driver...

Still I get the same error

Regards,

Teja

[Former Member]

Hi,

You need to deploy the drivers using this empty stub ( Please note from PI 7.1 onwards these empty stubs are provided).

To check if the driver is already deployed you need to check in some folder under /sap/usr if this stub contains the jar file of your driver.

Please take refrence of this note for deploying drivers using JSPM.

Note no: 1138877

Hope this helps.

Regards,

Siddhesh S.Tawate

[Former Member]

hi Siddesh,

We dont have to do anything for MS access right??

The PI 7.0 has been installed on MS operation system itself...

any ideas guys...

pls help me out

[Former Member]

Hi Ravindra,

Even in case of MS Access you would need to deploy drivers in my opinion. To access DB server through JDBC you need to have suitable drivers deployed.

One more thing, by "PI 7.0 installed on MS operations itself" you are referring to the database of your PI system.

JDBC is used to connect with specific databases like legacy database etc (databases other than your PI database).

Hope this helps.

Regards,

Siddhesh S.Tawate

[Former Member]

Hi,

I have gone thru the note...

can u tell me where I can get the jar for ms access database to add it to sda file and deploy it???

Regards,

Teja

[Former Member]

Hi Ravindra,

Please check the below thread. This might be helpful.

Regards,

Siddhesh S.Tawate

[Former Member]

Any Ideas guys?

[Former Member]

Hi,

Please check if the drivers are deployed correctly.

Regards,

Siddhesh S.Tawate