Connector to MS Access

[Former Member]

Hi ,

Experts i have a query.

I want xMII to Fetch data from MS Access database.

Please if someone let me know the steps involved and what connector to be used.

Connector parameters.

Mudit

[Former Member]

Use the xMII OLEDB UDS. This is the correct way to connect to access.

[Former Member]

Hi Martin ,

Please let me know is this a connector type xMII OLEDB UDS.

I am new to SAP xMII so can you please explain me this in a bit more detail.

Mudit

[Former Member]

Hi Mudit,

Yes the connector type is xMII OLEDB Connector.

Install the following on your local system:

Installation of the Lighthammer OleDb Data server (LHDS_OleDb_3_2_0_46_beta.zip)

Copy Pubs.xls and Northwind.mdb to a known directory (Only to demonstrate connection)

I have one document for the connection details.But not able to attach the document here.

Thanks,

Manisha

[Former Member]

Hi Mudit,

Visit this thread and read my response

https://www.sdn.sap.com/irj/sdn/profile?userid=3713794

Thanx & Regards

Vinod

Edited by: Vinod Ahir on Jun 4, 2008 7:11 PM

[Former Member]

Hi Vinod ,

I will tell you the steps i have done

Control panel -> Administrative tools -> Data Sources -> Created new User DSN with driver "Microsoft Access Driver"

Configured the same by selecting my Access database in it.

in xMII

selected OLEDB Connector and enabled the same

in Query template

am able to see the data source but i dont see any table which are there in my dtabase

Please suggest

Mudit

[Former Member]

hi,

here are the steps for connecting Access database,

goto Control Panel->Administrative Tools->Data Sources (ODBC)->Click System DSN Tab->Click ADD->Select driver to Microsoft Access in the list->Click Finish.

there will be another pop up asking for Data Source Name and Description and all there give a meaning ful name and description,

hit the select button, it will show for a browser window select the database which u have created, and select ok.

the new connection will be displayed in the System DSN tab,

now go to xMII menu->Data Servers->Uncheck the show only enabled servers check box->select default ODBC database->give a meaning ful name->in server URL it should be jdbc:odbc:<the name u have given as a Data Source Name in the Syatem DSN tab>->Enable it and check for status.

hope this will help u

[Former Member]

Hi ,

I followed these steps but not able to see the tables in the database

Mudit