JDBC MS ACCESS

[former_member190313]

Hi All,

For JDBC MS ACCESS lookup i am referring the following blog

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

in which says the database should be placed in the following path xiserver\xitemp\db\TestDB.mdb

but i am not able to find this path on our XI server.

Do v need to create the whole path.

Regards,

Sheetal

[former_member184619]

Hi Sheetal,

You can put it anywhere in XI box.

U can follow this link

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Sachin

[Former Member]

Hi Sheetal,

>> xiserver\xitemp\db\TestDB.mdb

This will be the path of your database. Here xiserver is the name or IP address of your XI Server, xitemp\db is the folder that you can create if it does not exist and TestDB.mdb is the name of your database.

Regards,

Subhasha Ranjan

[Former Member]

Sheetal,

You can put it in any other location and update the path in the 'Connection' string: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<b>//xiserver/xitemp/db/TestDB.mdb</b>;Uid=yourid;Pwd=yourpwd;

Kind regards,

Koen

[justin_santhanam]

Sheetal,

Create your own folder in XI Box and give the path over there.

Best regards,

raj.