Forum Discussion

jpanzeca's avatar
jpanzeca
Advocate I
8 years ago

specifying linked server

Can I specify a linked server in the data source settings?   I am able to write queries in SSMS by specifiying the linked server in the query.       SELECT * FROM [linked server name].[data base ...
jpanzeca's avatar
jpanzeca
Advocate I
8 years ago

Thanks Sonny,

 

I had tried that before and received the following error...

    The key didn't match any rows in the table.

jpanzeca's avatar
jpanzeca
Advocate I
8 years ago

I did find a work around by creating an ODBC connection and then changing each query to use the ODBC connection and the sql query.  This was a bit time consuming as I had over 20 queries but it works for now.

 

    = Odbc.Query("dsn=ODBC Connection", "SELECT * FROM [Link Server].[Database].[Table]")