Post reply

Linked Server

  • November 28, 2013 at 3:29 am

    #395910

    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".

  • November 28, 2013 at 6:28 am

    #1669673

    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?

  • November 29, 2013 at 5:32 am

    #1669807

    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