MySQL Forums
Forum List  »  Connector/ODBC

Connect from mssql 2017 to Mysql 8.0.15
Posted by: Xu Jiang
Date: October 31, 2020 08:29AM

1. This server is mysql community 8.0.15
2. Trying to create one linked server from mssql 2017.
3. The odbc driver using: mysql odbc 8.0 Unicode Driver.
4. From the odbc, connection testing is OK.
5. After I created a linked server, when try to expand the tables of the mysql databaes, it just showing like tables(expanding). And it just hung there.
6. When I do query, like
select * from openquery(linked_server, 'select count(1) from db1.transaction') As Trans.
The query can return the total number quite fast.

when I query
select * from openquery(linked_server, 'select transaction_code from db1.transaction limit 90') As Trans.
transaction_code: varchar(128)
It also return very fast.

But if I query:
select * from openquery(linked_server, 'select transaction_code from db1.transaction limit 91') As Trans.
The query just hung.

Looks like it quite related to the data size.

Hope anyone can help to answer this question. Great thanks.

Options: ReplyQuote


Subject
Written By
Posted
Connect from mssql 2017 to Mysql 8.0.15
October 31, 2020 08:29AM


Sorry, only registered users may post in this forum.

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.