Need steps to configure & access MS Access database from WebDynpro. Urgent!

[Former Member]

Hi,

Can any one please give me step by step instructions to access MS Access database from WebDynpro application.

I have J2EE engine running on my laptop (on which I deploy and test my Webdynpro application). I have MS Access 2007 installed on my laptop as well. I know that I need to create a Driver and Data source using Visual Admin but don't have enough information as to where to find the driver and parameters required to create the Data source. I also need some code sample to establish connection and get data from the access database tables. Please help.

thanks

Sudheer

[Former Member]

Hi Sudheer,

You can connect to an MSAccess Database using the JDBC adapter.

For that you can get the steps from--

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

Regards,

Swati