JDBC receiver error urgent

[Former Member]

Hello Friends,

I am using file to JDBC scenario.

i am getting following errors in the JDBC receiver though i have set all the parameters correctly.

the same scenario is working when i used XI server but it is giving errors when i am connecting to remote server.

i used sun.jdbc.odbc.JdbcOdbcDriver driver for the same.

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//bomwsap020/sugeet/AIP/DATABASE/Flight.mdb': SQLException: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

Please help on this.

thanks in advance.

Best Regards,

Sugeet.

[vijay_kumar133 · Accepted solution]

Hi sugeet,

The driver is not installed properly.. And check the port is opened from remot acces to that jdbc. mostly in driver and port problem this will arise,,. so check clealry this 2 things...

Thnaks & Regards

Vijay

[Former Member]

hi Sugeet

first check whether your user has the right to access Data base

Then check whether you have deployed the drivers correctly

You have to deploy the required JDBC drivers for the database before making connection. Ask the database provider or your vendor for the drivers That should be deployed using SDM tool

Start visual admin of XI and select service "Deploy" and then select option "Deploy and start" to select file and deploy it

Three option available:

1. Using SDM

2. Using Visual Admin

3. Using NW development studio (Not available for Production)

We will use Visual Admin u201CDeployu201D deploy service to deploy

Steps:

1. Goto VM->Deploy service

2. Select option u201CDeploy and startu201D

3. Select EAR file provided for deployment

4. Restart the service.

5. Done

follow this guide on how to install external libs for JMS/JDBC

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how%20to%...

regards

Sandeep

If helpful reward points

[Former Member]

HI,

Check the JBBC drivers.You need to deploy the required JDBC drivers for the database you are trying to connect to. Ask the database provider for the divers. They should be provided by them and you basis team should deploy them on the XI server using the SDM tool.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Thanks,

Soumya.

[Former Member]

Did you install the driver to access the DB in your XI server. It is not able to recognise the Driver.

Check if you have deloyed the drivers correctly . Refer to following config guide for delopyment steps .

http://service.sap.com/~form/sapnet?_SHORTKEY=01100035870000591425&_OBJECT=011000358700001697502004E

Note: reward points if solution found helpfull

Regards

Chandrakanth.k

[Former Member]

Hi,

there seems to be some problem with JDBC adapter....

plz refer to this link...i think it will help u...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

reward points if helpful...

PRasHant