Linked Server

  • Hi,

    I have recently setup a linked server from sql server 2012 to MySQL.

    I am able to see the db and table details at left side panel.

    But when I am trying to select the data from the table, it is showing error like this.

    OLE DB provider "MSDASQL" for linked server "MySQLLinserver" returned message "[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.20]No database selected".

    Msg 7306, Level 16, State 2, Line 1

    Cannot open the table "TableName" from OLE DB provider "MSDASQL" for linked server "MySQLLinserver".

  • This is solved by giving db name in the ODBC.

    Is it any way access the db from MY SQL thru Linked Server, without mentioning the db name in ODBC?

  • Can I access multiple db from MY SQL using one Linked Server?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply