Home Forums SQL Server 2008 SQL Server 2008 - General Linked Server (MYSQL) links ok, but cannot see tables and queries return errors RE: Linked Server (MYSQL) links ok, but cannot see tables and queries return errors

  • mariann harper (5/17/2011)


    I followed the steps in this article and successfully got a Linked Server on SSMS.

    http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

    The database is there, but no tables are visible. Aren't I supposed to be able to view the tables, just like regular SQL Server tables can be viewed? None are listed.

    ----------------------

    I also ran some code manually to get info on a table:

    SELECT * FROM OPENQUERY (MYSQL, 'SELECT * FROM Mytable')

    and got this error:

    An unexpected NULL value was returned for column "[MSDASQL].checked_out_time"

    from OLE DB provider "MSDASQL" for linked server "MYSQL". This column cannot be NULL.:hehe:

    Both issues are likely due to the fact that the version of MySQL database your connecting to does not contain an implementation of INFORMATION_SCHEMA consistent with ISO standards. It could also be a driver issue.

    What version of MySQL are you connecting to? What version of the MySQL ODBC driver are you using?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato