How to setup connectivity to Microsoft Access DB 2007

, ,
1

Hi,

We have a requirement to connect to Microsoft Access DB 2007 and we are currently using webMethods IS 8.2.1 and JDBC Adapter 6.5. Could anyone of you tell on how to setup Connectivity to MS Access DB 2007 (.accdb)?

We need to insert the data from webMethods to Microsoft Access DB.

Thanks in advance,
Pradeep

2

Please check the 8.2 system requirement documents…It doesn’t show the MS Access db.

The JDBC Adapter supports the following databases only:
?
ADABAS for z/OS with CONNX
?
DB2 for AS/400
?
DB2 for OS/390
?
DB2 Universal Database (UDB)
?
IBM Informix
?
Microsoft SQL Server
?
Oracle
?
Sybase
?
Teradata
?
Postgres Plus Advanced Server 9.0

Did you check using WmDB package try to access it?

Please contact SAG support for more guidance and alternate options for faster action.

HTH,
RMG

3

Thank you for quick reply.

Could you pls let me know how to pass the input parameters (Driver, Alias, URL, DB Properties etc) and do we need to do any configuration in MS Access?

4

First you need to check with SAG support if they support MS Access via WmDB or any other way.

I don’t have any information on the URL or DB driver to use for Access DB.

But in general DB URL format will be example for SQL Server.

jdbc:microsoft:sqlserver://hostname;DatabaseName=TNDB;SelectCursor=true

DB Driver:com.microsoft.jdbc.sqlserver.SQLServerDriver

And then test teh connection via WmDB home page after Add and Edit section.

HTH,
RMG

5

Thank you for your response. I will check with Software AG support…