JDBC Error while importing table metainformation

[stefan_bosshard2]

Configured a jdbc communication channel for a MS Access 2010 database. Driver successfull installed.

Now I try to import database table into "external definition".

As cou can see connection to db table Partner1 was successfull. But when I go on with Finish following error occurs:

Exception caught when executing

statement for table/stored proc. 'metadataRequest' (structure 'statement'):

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support this function at

sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6973)

So I am not sure, if I have to change something in JDBC communication channel etc.

The table has only three column id, name and firstname

Any ideas?

Thanks and regards

Stefan

[former_member192343]

Hi,

what if to select "do not extract" for messages?

The error says "Driver does not support this function", so you can't extract messages for this connection, only data structure.

[stefan_bosshard2]

Hi Mikhail,

I just changed it to "do not extract" but I got the same error messages......

Regards

Stefan

[former_member192343]

so your driver doesn't allow this.

[stefan_bosshard2]

Correct - driver does not support this feature. I had to create "INSERT" sql by myself and now it works. Thanks for that issue.