cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to connect MSAccess with SAP-MII

Former Member
0 Kudos
432

Hi All,

Can I know how to connect MS Access to SAP-MII and the procedures?

Also what are the Jar files to be deployed?

View Entire Topic
Former Member

Hi Parthee,

Do the following steps:

1) In SAP PCo 2.1, create a source system of type "OLE DB Agent"

In Provider Select "Microsoft Jet 4.0 OLE DB Provider"

In Connection Tab select the mdb file

Give the login details if required and Test the Connection

Go to the advanced Tab and check the access permissions.

2) Create an agent for this and select appropriate port type depending on the MII Version

If 12.2 select MII and give a port no e.g 9000

If 12.1 select legacy and give a port no e.g 9001.

3) Start the Agent & make sure its successful.

4) In MII, Create a Data Server of type OLEDB, give the IP address and the port(the port which you created in PCo).

5) Enable, Save and Test.

Hope this helps.

Regards,

Tony.

Ask a Question