Why can not I get any row in a MySQL query from SQL Server? The problem I have is that I can not visualize any row with the following query:

SELECT * FROM OPENQUERY ([LINK_MYSQL], 'SELECT * FROM mysql.vw_bd_date;')


The query did not show any error except that it did not throw me any lines either. The consulted view found in MySQL is the following:

create view vw_bd_date
as
SELECT `information_schema`.`TABLES`.`TABLE_SCHEMA` AS `base_de_datos`,MIN(`information_schema`.`TABLES`.`CREATE_TIME`) AS `FECHA_CREACION` 
FROM `information_schema`.`TABLES` 
WHERE ((`information_schema`.`TABLES`.`TABLE_SCHEMA` NOT IN ('information_schema','sys','mysql','performance_schema','test','test\\_%')) 
AND (`information_schema`.`TABLES`.`DATA_LENGTH` IS NOT NULL) AND (`information_schema`.`TABLES`.`INDEX_LENGTH` IS NOT NULL)) 
GROUP BY `information_schema`.`TABLES`.`TABLE_SCHEMA`


This is the use in a much larger query where I do the join with other views to perform a database inventory, but also as commented, the fields in this particular view throw me NULL.

We tried to do all kinds of cast without success.

Any idea would be very helpful.

Thank you
As I'm obviously not even close to proficient in MySQL, my answer won't really focus on that side of your question.  If the view returns what you are expecting from within MySQL, I suspect the issue is on the SQL Server side.  What driver are you using?  If it's the built-in Microsoft driver for MySQL, I would strongly recommend downloading the MySQL Driver from their site and installing that as a new provider on your SQL Server.  When connecting to other RDBMS systems, I have had significantly better luck using the driver provided by the vendor of that application rather than using the generic driver provided by Microsoft.