I am writing a query across a linked server in SQL Server 2005 and am getting the error below about an extra token.
OLE DB provider "MSDASQL" for linked server "Live_Navision" returned message "[Navision a/s][Navision Attain ODBC Driver]Unexpected extra token: .".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "select ManitouSerialno from Navision.dbo.InterfaceSecuritySystemsLLC$CustomerTable" for execution against OLE DB provider "MSDASQL" for linked server "Live_NAVISION".
View Complete Post