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

  • You can try retrieving the column names from INFORMATION_SCHEMA like this:

    EXEC ('SELECT TABLE_SCHEMA,

    TABLE_NAME,

    COLUMN_NAME

    FROM INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = ''MyTable''

    AND TABLE_SCHEMA = ''SchemaName'' ;') AT [MYSQL] ;

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