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

  • Thanks. You won't be able to browse your complete MySQL object hierarchy through the SSMS Linked Server node for the reason I mentioned in my previous post about them not coding up to ISO standards but you should be able to pull data. I think all you need to do is start qualifying your table names, like this:

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

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