MySQL Forums
Forum List  »  Connector/ODBC

mysql table cannot be imported in Data Service
Posted by: Jason Zhang
Date: November 07, 2022 02:12AM

We are using Data Service 4.2 SP14. The Datastore for mysql could be created and we could see the table name.

However when we want to import the table, we encountered the following error. We tried two users of mysql DB, one is with the read only access and the other is with full access. But neither of them works. Could you please let us know how to resolve this issue? Thanks!

Error:Cannot import metadata.
ODBC data source : error message for operation <SQLFetch>:[MySQL][ODBC 8.0(W)] Driver][mysqld-5.7.33-log]Fetch without a SELECT>.(BODI-1112338)

Options: ReplyQuote

Written By
mysql table cannot be imported in Data Service
November 07, 2022 02:12AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.