Receiver JDBC - MS Access from SunOS 5.9

[Former Member]

Hi,

We are trying to insert records into MS Access using JDBC adapter. Our XI 3.0 (SP15) server is on SunOS 5.9.

As per the blog

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

Have configured the following parameters.

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

( Tried with "jdbc.odbc.JdbcOdbcDriver" aswell but it gave SAPClassNotFound Exception)

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=<Full DB File Path>

Adapter Monitor shows adapter in green status.

But with the above parameters the java stack is getting restarted each time we try to send a message to MS Access.

(similar to the thread )

The RWB -> Adapter Engine message goes into System Error

without any error message in the Audit Log.

Has anyone faced similar issue and found a soultion ?

We do not want to use drivers from third party vendors.

Does microsoft/sun provide any drivers for accessing MS access from SunOS 5.9 ?

Any inputs on the same would be appreciated.

Thanks

-Anand

[former_member556603 · Accepted solution]

Hi,

Go through these links,

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

http://searchsap.techtarget.com/tip/0,289483,sid21_gci1246926,00.html

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

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

Please check the driver path as mentioned below.

JDBC Driver : sun.jdbc.odbc.JdbcOdbcDriver

Connection:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=//location of DB table.mdb;

No JDBC driver required.

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

follow this thread

SAP Note 850116 has details

Thanks,

Satya Kumar

[Former Member · Accepted solution]

As per note 850116 does MS Access provide native libraries/dlls for Sun OS ? How/where can I get the same ?

[GabrielSagaya · Accepted solution]

You can use Sun ODF Plugin for Ms-Office.

http://www.sun.com/software/star/odf_plugin/index.jsp

Or you can StarOffice too.

[GabrielSagaya]

SAPClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver --> This error clearly implies that the MS-Access has not been installed on your XI server.

Ask you admin team to do the needful and install the MS-Access.

[Former Member]

it does not give error when I use "sun.jdbc.odbc.JdbcOdbcDriver"(adapter staus is green), but java stack gets restarted and Adapter Engine message goes into system error with out any error message.

it gives class not found exception when I use just "jdbc.odbc.JdbcOdbcDriver".