File to Xi to MsAccess through jdbc

[Former Member]

hi,

All I am trying a scenario file as outbound and Xi is updating records in MS Access data base;

I was follwing this weblog:

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

every thing is fine here.

In SXMB_MONI it shows the message is successful whiel run time workbench it shows with system error.

--> Here I am accessing MS Acccess database locally from my machine. I shared the folder and give the path connnection string.

1) In this scenario, can I access the Ms-Access locally with XI server?

2) if yes then why I am not able to update the database.

In auditlog ... it says : Please check

Time Stamp Status Description

2007-05-11 06:52:04 Success Message successfully received by messaging system. Profile: XI URL: http://cmis147.nwk.amer.csc.com:50000/MessagingSystem/receive/AFW/XI Credential (User): XIISUSER

2007-05-11 06:52:05 Success Using connection JDBC_http://sap.com/xi/XI/System. Trying to put the message into the receive queue.

2007-05-11 06:52:05 Success Message successfully put into the queue.

2007-05-11 06:52:05 Success The message was successfully retrieved from the receive queue.

2007-05-11 06:52:05 Success The message status set to DLNG.

2007-05-11 06:52:06 Success Delivering to channel: Access_DB_Recieve

2007-05-11 06:52:06 Success MP: entering

2007-05-11 06:52:06 Success MP: processing local module localejbs/CallSapAdapter

2007-05-11 06:52:06 Success Receiver JDBC adapter: processing started; QoS required: ExactlyOnce

2007-05-11 06:52:06 Success JDBC adapter receiver channel Access_DB_Recieve: processing started; party , service DB_Receive

In Message data it has these values :

-

---

Attribute Value

Status System Error

Repeatable Yes

Cancelable Yes

Error Category XI_J2EE_ADAPTER_JDBC

Error Code DATABASE_CONNECT_ERROR

Start 11.05.2007 06:52:04

End 11.05.2007 07:07:10

Sender Party

Sender Service File_Receive

Receiver Party

Receiver Service DB_Receive

-

---

Please check and correct me where I am doing wrong.. TIA

Ram Singhal

[Former Member]

Hi-

<i>1) In this scenario, can I access the Ms-Access locally with XI server?</i>

Yes you can access

<i>2) if yes then why I am not able to update the database.</i>

Check if the JDBC adpter is configured properly and also if the cache is updated.

Hope this links helps you.

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step -- JDBC receiver adapter (synchronous step by step)

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn -- Connect to MS Access database using reciever JDBC

For Configuring jDBC adapter -

http://help.sap.com/saphelp_nw2004s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

[Former Member]

<i>1) In this scenario, can I access the Ms-Access locally with XI server?</i>

Your database and table should be placed in XI server and have to give that paticular path in Adapter connection string If you are using MS Access

[Former Member]

Thanks Sekhar,

one more question :

What about Oracle and SQL Server ? or is there any way to access local MS-Access through XI ....

I used ftp and it is recognizing my machine.

and I shared the DB folder with full access then do you think it should not be accessible. ?

Please correct .....

[Former Member]

<i>What about Oracle and SQL Server ?</i>

You can access these databases from any machine.

<i>is there any way to access local MS-Access through XI ....</i>

NO...