RE:[sap-basis] XI 3.0 Communication channel error to MS access
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Raghav (SAP PI Basis Consultant) on May 5 at 11:12 AM |  Mark as helpful |
Hi:
You need a JDBC driver for this.
I am not sure where you would source this, but i remember sourcing this once from the oracle client drivers on our system.
Once done, please send it to your basis Team after having them bundle it into the aiijmsproviderlib.sda file and have them deploy it.
Regards,
Raghav
---------------Original Message---------------
From: dbasis77
Sent: Thursday, April 29, 2010 5:13 PM
Subject: XI 3.0 Communication channel error to MS access
> Hi All,
>
> We have created a file to JDBC scenario on XI 3.0. My XI server is on a Linux server and the db the receiver CC is trying to connect to is an MS Access 2007.
>
> The CC parameters are configured as follow:
>
> JDBC Driver: jdbc.odbc.JdbcOdbcDriver
> Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=\\xxxxxx\xxxxx\Test.mdb
>
> On the communication monitoring we are getting the following error message:
>
> Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePool Exception: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=\\xxxxxx\xxxxx\Test.mdb': java.lang.NullPointerException
>
> In regards with the above message and after reviewing several forums, I have two questions I would like to confirm with you:
>
> a- Do I have to perform a JDBC driver deployment to connect to a MS Access DB? If so, which one.
> b- Is there a suitable JDBC driver on Linux to connect to a MS Access DB? If there is not such a driver, Is there any available workaround for this?
>
> Please, let us know your recommendations about this or what I should check to identify the cause of the above error.
>
> Thanks and best regards
__.____._ You need a JDBC driver for this.
I am not sure where you would source this, but i remember sourcing this once from the oracle client drivers on our system.
Once done, please send it to your basis Team after having them bundle it into the aiijmsproviderlib.sda file and have them deploy it.
Regards,
Raghav
---------------Original Message---------------
From: dbasis77
Sent: Thursday, April 29, 2010 5:13 PM
Subject: XI 3.0 Communication channel error to MS access
> Hi All,
>
> We have created a file to JDBC scenario on XI 3.0. My XI server is on a Linux server and the db the receiver CC is trying to connect to is an MS Access 2007.
>
> The CC parameters are configured as follow:
>
> JDBC Driver: jdbc.odbc.JdbcOdbcDriver
> Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=\\xxxxxx\xxxxx\Test.mdb
>
> On the communication monitoring we are getting the following error message:
>
> Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePool Exception: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=\\xxxxxx\xxxxx\Test.mdb': java.lang.NullPointerException
>
> In regards with the above message and after reviewing several forums, I have two questions I would like to confirm with you:
>
> a- Do I have to perform a JDBC driver deployment to connect to a MS Access DB? If so, which one.
> b- Is there a suitable JDBC driver on Linux to connect to a MS Access DB? If there is not such a driver, Is there any available workaround for this?
>
> Please, let us know your recommendations about this or what I should check to identify the cause of the above error.
>
> Thanks and best regards
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Related Content
In the Spotlight
White Papers
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
